Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a data set like the below data set which has State wise Company Sales.
The requirement is to find Rank 1 Company in State A,B,C in a pivot table.
The desired output is like.
Please help, thanks in advance.
Dimension 1: State
Dimension 2: Company
In my case i have only State as dimension in pivot table so this expression will only return Sales for Rank 1 State. so this is not fulfilling the requirement
please can you provide me the logic as i dont have qlikview to open this file.
T:LOAD * INLINE [State, Company, SalesA, C1, 500B, C1, 600C, C1, 4000A, C2, 450B, C2, 800C, C2, 950A, C3, 1000B, C3, 2000C, C4, 3500];
Dimension : -State, Company
Expression : if(rank(Sales)=1,Company)
In presentation Tab, please hide Dimension Company
If you are interested in the name of the company try:
FirstSortedValue(Company, -Aggr(sum(Sales), State, Company))