topic Dynamic Sorting with Cyclic Groups in QlikView

Dynamic Sorting with Cyclic Groups

Tue, 25 Mar 2014 17:59:21 GMT

Hi all, cyclic groups is great when I was making a chart to breakdown sales by different dimensions.

BUT, what if I need to sort it with expression using match function for a specific demension?

Thanks so much!

example: I need to sort the Price Range, so that it's from low price range to high price range. How to do it if this dimension is in cyclic group?

maxgro — Tue, 25 Mar 2014 18:53:20 GMT

if I understand your question you can conditional sort depending on the field you show using GetCurrentFieldofthe cyclegroup

example

if(GetCurrentField("<<KPICycle")='Sales Rep', wildmatch([Sales Rep], 'A*', 'R*', '*'),

if(GetCurrentField("<<KPICycle")='Product Group', wildmatch([Product Group], 'S*', 'B*', 'R*', 'A*', '*'),

wildmatch([Item Desc], 'Bett*', 'BB*', '*')

))

Tue, 25 Mar 2014 19:12:33 GMT

Thank you Massimo, this is what I am talking about