Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Above function with 2 dimensions

Hi All,

Have a table with having 3 fields..like below

 

monthratingactive
janA21
janB22
janC23
janD24
febA25
febB26
febC27
febD28
marA29
marB30
marC31
marD

32

Output:

 

monthratingactiveOutputresult field
janA21
janB22
janC23
janD24
febA2521
febB2622
febC2723
febD2824
marA2925
marB3026
marC3127
marD3228

Here am attaching the Qvw for the same which i tried.

Basically every month having 4 type of ratings and their activity.

Want to show for jan month activity should show in feb activity and feb activity should show in Mar activity....

I have been used some functions with combination of above but am not getting correct result.

Thanks in advance...

2 Replies
swuehl
MVP
MVP

You've almost done it.

Just change the order of aggr dimensions

only( aggr (above(sum( {$<month=,rating=>}active),1,4),rating,month))

effinty2112
Master
Master

Hello,

Maybe:

month rating sum(active) above(TOTAL sum(active),4)
318  
janA21 
janB22 
janC23 
janD24 
febA2521
febB2622
febC2723
febD2824
marA2925
marB3026
marC3127
marD3228

Just ensure that your table is sorted by month then rating.

Regards

Andrew