Discussion Board for collaboration related to QlikView App Development.
I am new to the community. I have the requirement to display bar chart based on highest priority.
If a person has priority 1 and 2 then we need to consider the priority based on the latest date.
Please help how to write the rank script for the bar chart. You can find the data below.
Attached Sample of the chart:
What do you mean by priority here? How are you defining it?
Priority is defined in backend load by considering Apple priority-1, Orange-2, Banana-3, Grape-5.
we have to display the chart by displaying the number of persons tagged for the fruit name based on the rank.
If a person is tagged both apple and Orange then the chart has to consider the person id only for apple as apple is priority-1.
Please let me know if you need any other info.
To be honest, I didn't get the real result that you want.
So could you please tell me what's the result you want according to the data you gave above?
Couldn't get the logic 😞
Hi Aiolos Zhao,
I have fields as follows:
Action- outcome action
Rank-rank (pre-defined as (CA : 1, DA :2, WA : 3, NA : 5)
Date: Created Date
Requirement: Need to count the number of persons for each Action item based on the rank.
rank1 is the highest. If a person tagged to rank 1 and rank2 then we need to count the person tagged to rank1 and ignore the count for rank2.
Please see the below outcome results based on the aggr function that I defined:
highest priority CA is mapped to 18 persons but few of the persons are also tagged to DA, WA, NA, please see pic2. Based on the requirements, i need to ignore lower rank DA,WA,NA for those repeated persons and consider only CA.
So the result you expect is below table?
am I right? if not, please show your expect result.
Yes, the output should be
I tried aggr and firstsortedvalue functions but could not able to get the above result.
I don't know whether you can left join a table in back-end,
I left join a rank table in back-end, and change the data source for testing the expression,
I think below is what you want :
Backend, I did leave join and the outcome results should be as specified below. DA, WA, and NA should be 0 because the persons under these elements also belong to CA and CA is the high priority.