Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use set analysis in dimension where the dimension is not changed for selecting the date. I used an expression which is given below:
Aggr(Only({<Year-=>} Stype), Stype)
Aggr(Only({<Year=>} Stype), Stype)
Aggr(Only({<Year>} Stype), Stype)
But these three expressions are not working.
If Anyone know about this help me. Thanks in advance 🙂
You are selecting Date or Year?
This should work if your goal is to ignore Year selection in your expression.
Aggr(Only({<Year=>} Stype), Stype)
If you want to ignore date,try adding date into the expression as well.
Aggr(Only({<Year=,date=>} Stype), Stype)
Do you have a sample app?
Per Arthur's request, are you able to provide any sort of sample app here, believe that is going to be necessary for you to receive further help on things. If you figured things out on your own, please consider posting what you did, and then mark that post using the Accept as Solution button so others will know what worked. If you can post a sample app or further details, perhaps someone will be able to offer further guidance. Outside that, the only thing I have to potentially help is the follow Design Blog link on Set Analysis that has some other links at the bottom of it as well that may be helpful.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
The Dates in Set Analysis link at the bottom of the post may be the more pertinent link, just FYI.
Regards,
Brett
I think the issue is that ignoring a filter within Dimension doesn't really control the chart. In order to do this, you will need to ignore selection in the expression.... So something like this
Dimension
Aggr(Stype, Stype)
or just
Stype
Expression
Sum({<Year>}Measure)