Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic grouping of the expressions based on the metric value

Hi All,

Requirement is to create 4 groups dynamically based on the maximum value of the sales (metric) for the selected dimension combination in the pivot table.

Dimensions in the table changes dynamically as it is using cyclic groups and conditional dimensions.

All the 4 groups are based on the maximum value of the sales metric for the selected dimensions.

Group 1 range: sales > (0.75*Max(sales)) and sales <=Max(sales)

Group 2 range: sales> (0.5*Max(sales))  and sales <=(0.75*Max(sales))

Group 3 range: sales> (0.25*Max(sales)) and sales <=(0.5*Max(sales))

Group 4 range: sales> (0.25*Max(sales))

Expected output:

Region Title  Group1  Group2   Group3    Group4

Asia     MD     100      200          150            50

Asia     VP       250     175         150            100

Region, Title are dimensions and Group1 - Group4 are expressions based on the above critiria.

Could you please advice on if this can be achieved in UI?

1 Solution

Accepted Solutions
Not applicable
Author

Hi Manish,

I have posted more details in another discussion:

http://community.qlik.com/message/462121

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Can you upload your sample file?

Not applicable
Author

Hi Manish,

I have posted more details in another discussion:

http://community.qlik.com/message/462121

View solution in original post