Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Master
Master

Need a table based on below conditions

Hi Guys

Need your help here. Please check below table.

    

Sr. NoMonthDMU NamesLocationABCDE
1AUGKeralaIndia10232235
2AUGDelhiIndia124525567
3AUGNoidaIndia2653
4AUGLucknowIndia643
5AUGDelhiIndia1367254
6AUGDelhiIndia6823
7AUGLucknowIndia146323
8AUGKeralaIndia177233598
9AUGNoidaIndia1933254
10AUGKeralaIndia203439

Through this table, i need below table

ProductAugBenchmark
A230
B330
C130
D230
E3

30

Here bench mark should be editable and dynamic and logic for getting the values below Month(AUG) is

lets take eg for A, so here '2' signifies the count of DMUs whose sum(A) is greater than benchmark.(Kerala and Noida)

Please help, and i don't have license as of now, so kindly help with the expressions and script as well.

0 Replies