Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

shamiul_islam
New Contributor II

Set Analysis in Dimension

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 🙂

Labels (2)
5 Replies
Partner
Partner

Re: Set Analysis in Dimension

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)

shamiul_islam
New Contributor II

Re: Set Analysis in Dimension

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

Re: Set Analysis in Dimension

Do you have a sample app?

Support
Support

Re: Set Analysis in Dimension

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Re: Set Analysis in Dimension

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)