Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
lylererger
Contributor II

Calculated Dimention/Sort Order/Original

Hi friends!

Help me to fix set analysis script of load order in chart.

Formula of calculated dimention is:

=Aggr( Only({1< _MENU_ПРОДУКТ = P({1<_MENU_СОРТИРОВКА ={$(=Concat('['&[_MENU_СОРТИРОВКА]&']',','))}>} )>} _MENU_ПРОДУКТ ), _MENU_ПРОДУКТ,_MENU_СОРТИРОВКА)

Sort Formula is:

Only({1< _MENU_ПРОДУКТ = P({1<_MENU_СОРТИРОВКА ={$(=Concat('['&[_MENU_СОРТИРОВКА]&']',','))}>} )>} _MENU_ПРОДУКТ )

Now menu looks like here:

_1.PNG

But the product "КФЛ" should be on the first like:

_2.PNG

I just need Original Load Order

Please help!

Thanks in advance!!!

P.S.: demo app in attachment...

1 Solution

Accepted Solutions

Re: Calculated Dimention/Sort Order/Original

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
4 Replies

Re: Calculated Dimention/Sort Order/Original

I don't have access to open your file, But can you try with "Load Order"checked in sort tab for Product?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
lylererger
Contributor II

Re: Calculated Dimention/Sort Order/Original

It is not working

Re: Calculated Dimention/Sort Order/Original

PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
lylererger
Contributor II

Re: Calculated Dimention/Sort Order/Original

Thanks