If you hide rows, columns and data on excel, the chart that’s uses this data also hides it — while this is the default behavior, you can override this by following the steps below.
Let’s reproduce the behavior first.
I have a simple excel chart like shown below:
Now, if I hide the data that is selected for this chart then the chart stops showing this as well:
To fix this and if you want the cells (rows, columns and data) to be still hidden but still have the chart show up, then follow the steps:
Select the chart
Under Chart Tools > Design > Select Data
Click on Hidden and Empty Cells
Check the Show data in hidden rows and columns check-box
Go back to excel and you should see the data on the chart now even though the data is hidden
(This post first appeared on the Qlik Community. here)
Problem:
So you just joined a Business Intelligence Team and one of the responsibilities include building apps for your business users. Eventually, you would have a need to see Data Load editor scripts for apps developed by other members in the team. So what permission do you need to be able to do that?
1) Get “content admin” access (or “higher” level access)
2) Double check if you have access to see data load scripts for ALL apps
Step 1:
The short answer is that you need “Content Admin” permission from your Qlik sense admin…But with this access level, you will have access to other developer’s app via QMC. If you need to do this via HUB as well then you will have to change the content admin role.
Here’s how Serhan ( darkhorse ) explained how to get this done:
QMC–> Security Rules–>Content Admin–> Edit–> Context–> Both in Hub and QMC
Step 2:
Now, once you get the “content” admin access, you might want to double two things:
1) You can get access to data load scripts on published apps — (I was able to do this but there still seems to some open questions around some folks not being able to see the data load scripts for published apps. If this is the case for you, you need to duplicate the app on your “my work” area and see the scripts)
2) You can duplicate apps on your “my Work” area and see scripts — this is also useful if you want to make changes to published apps that are out there.
Conclusion:
I hope this helps you resolve the permission issues and help you collaborate with your team members!
I saw this ad on a highway earlier today and my reaction: why would I switch to a network that has just “96%” coverage.
T mobile ad — example of data puking
…instead of converting a potential buyer, this ad actually made me more nervous. You know why? Its a case of what I like to call “data puking” where you throw bunch of numbers/stats/data at someone hoping that they will take action based off of it. So what would have helped in this ad? It would have been great to see it compared against someone else. Something like: we have the largest coverage compared to xyz. My ATT connection is spotty in downtown areas so if it said something like we have 96% coverage compared to ATT’s 80% then I would have been much more likely to make the switch.
I wrote about this adding benchmark in your analysis here
Takeaway from this blog: don’t throw data points at your customers. Give them the context and guide them through the actions that you want them to take.
How do you customize the Legend Text on a chart? by default, it’s going to show you the name that you have in the Data Set, but sometimes that’s not what you want to display so how do you change the name?
It’s really useful when you don’t want to change the name of field in the dataset or when you are using an expression as an item on the chart and you need to display a business user friendly name on the report:
Solution:
1. Go to Chart Data Properties:
2. To change the Legend Text of “Sales Amount CY” – Navigate to series properties of the “Sales Amount CY” series:
3. Go to “Legend” and enter the Text in the “Custom Legend Text“:
4. You can customize text for all legends on your report by navigating to the series properties.
Conclusion:
In this post, I walked you through how you can customize the legend name/text in SQL Server Reporting Services.
SSRS chart didn’t show all axis labels. Here’s an example.
Note: it does NOT show all country names:
Solution:
So what do you do if you want to show all axis labels in the report and do not want to skip the axis labels? Here are the steps:
1. Go to the Chart Axis properties
2. Under Label, change the value of Label Interval from Auto to 1
3. Preview your report to see if you see ALL axis labels now:
Conclusion:
The above chart is NOT perfect. There are other things that can be done but the goal of the blog post has been achieved! We have changed the axis label property so that all axis labels now show up on charts.
Data Visualization is an art. No doubt about it – I admire professional artists that can create “beautiful” data visualizations. And Data visualization involves more than one technique – one being representing data using charts. And if you have experience in this domain then you know that there are Many charts out there.
Resource: You can browse Google Charts Gallery here to see various options you have.
Now, how do you choose between these options when confronted with the challenge of creating effective charts? wouldn’t it be great if we knew of a resource that could help us get started?
well, I found this resource which I think can help you get started on which charts you can use:
Now, if I hide the data that is selected for this chart then the chart stops showing this as well:
To fix this and if you want the cells (rows, columns and data) to be still hidden but still have the chart show up, then follow the steps:
T mobile ad — example of data puking
