topic Re: Set Analysis in Dimension in QlikView

Set Analysis in Dimension

shamiul_islam — Sat, 16 Nov 2024 02:14:22 GMT

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 🙂

Re: Set Analysis in Dimension

Arthur_Fong — Mon, 14 Oct 2019 00:43:58 GMT

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)

Re: Set Analysis in Dimension

shamiul_islam — Thu, 17 Oct 2019 04:22:03 GMT

I was trying those two fomula also, but none of them were working Jkfong93

Re: Set Analysis in Dimension

Arthur_Fong — Thu, 17 Oct 2019 04:25:10 GMT

Do you have a sample app?

Re: Set Analysis in Dimension

Brett_Bleess — Mon, 21 Oct 2019 15:59:42 GMT

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

Re: Set Analysis in Dimension

sunny_talwar — Mon, 21 Oct 2019 16:19:05 GMT

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)