Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Sense Experts
I am new to Qlik Sense Desktop and I have a complicated front end question as below
The raw data shows that how many times an order change
My app is as below
=aggr (Count([DateOf Chg]), [Link-SO&Item])
=> This is to count how many [DateOf Chg] of each [Link-SO&Item] has.
=Country
=> Count(distinct [Link-SO&Item])
=Aggr(if(Count({<[Link-SO&Item]={'=Count([DateOf Chg])>1'}>}[DateOf Chg])>1,'y','n'), [Link-SO&Item])
My Question is as below
1.There should be ‘y’ and ‘n’ in the filter but only ‘y’ stands there, why?
2. When I click the number on the chart (e.g. ‘2’), there should be a filter to show me I have selected ‘2’ so that I can easily change to other number I need in the 1st layout. But there isn’t any. How can I make it happen
You can check the raw data and qvf file in the attachment for your reference
Thank you for your advice in advance
Ivan
For the first requirement, change your filter pane's expression to this
=Aggr(if(Count([DateOf Chg])>1,'y','n'), [Link-SO&Item])
Not sure how to get the 2nd req working
For the first requirement, change your filter pane's expression to this
=Aggr(if(Count([DateOf Chg])>1,'y','n'), [Link-SO&Item])
Not sure how to get the 2nd req working
Sunny
Sorry for the late reply.
Your expression works, thank you so much
For question 2, seems the selection can't display on top bar if we set expression in master item (dimension)
Lets say if I set 'Today()-Order Date' in master item (dimension), the result is same that nothing shows up in top bar after I select data in this new dimension
Ivan