Discussion Board for collaboration related to QlikView App Development.
Is it possible to create a chart to count how many times appear of a calculated item? I tried but unable to do so.
Yes its possible. ONe of the way of doing it is creating a field at script level.
if((count) <= 5 , 'Low usage' ,if(count > 5 and count < 20 'Mid USage', if(count >20, 'High Usgae'))) as Calculateditem,
Now in Fron end add the two dimension COuntry and Calculateditem and in expression count( Calculateditem ).
I hope this helps.
Thanks for your suggestion. But I do not want this to put into the loading scripts because the data consists of 2 years data in transaction level and thus, the number of count is also a calculated item as well. In QV, will have a selection page for users to choose whether they want to see the monthly, bi-monthly, quarterly, yearly, etc. Hence, pre-calculate in the scripts does not work.
I want the chart can be dynamically change based on the users' choice in selection page.
Thanks a lot and it works.
Moreover, I added more data, country field as well, to your qvw file and plot a chart as attached.
I found that since there are too much values on the x-asis, the chart is unable to show all the country and thus, it hided some of them. I would like to ask
1) You can see that even there is no staff in AU for Prod A, but the chart still having AU in A. Can I remove all the value in X-asis which is not exists to the specific Prod. For example, I just want to show CN, ID and IN for Prod D.
2) If 1 cannot be done, then will face another problem is not all the countries are shown in the chart. For example, CN label in x-asis is missing but the CN bar is there. This will confuse users. What should have do in order to show all?