topic Re: Front end Selection Working and Set Analysis not working in QlikView

Front end Selection Working and Set Analysis not working

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

By Selecting March from Month_New List Box I am getting the Correct Result.

But when I am adding Current Month in Calculated Dimension Set Analysis than I am

getting Wrong Result.

How to achieve the desired Output.

See this:

I have Attached the qvw for Reference.

Regards

Cire

Re: Front end Selection Working and Set Analysis not working

Wed, 28 Sep 2016 18:13:27 GMT

Anyone faced such issue than please share your inputs

stalwar1‌

Sir Please help

Regards

Cire

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 18:17:55 GMT

Here are the changes that you need

Calculated dimension:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code)<=3,Code,'Others')

Expressions

Sum({<Month_New={'Mar'}>} Value)

Sum({<Month_New={'Mar'}>} Amount)

Re: Front end Selection Working and Set Analysis not working

Wed, 28 Sep 2016 18:20:41 GMT

stalwar1‌

Sir I can only use the Max Month in Calculated Dimension.

In my Actual Application, the Expressions are so complex.

What to do now??? Any workaround for this.

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 18:24:59 GMT

Use Max Month? Not sure I understand your question

Re: Front end Selection Working and Set Analysis not working

Wed, 28 Sep 2016 18:31:30 GMT

stalwar1‌

Sir I am saying that I can't use Max Month in my Expressions like this:

Expressions

Sum({<Month_New={'Mar'}>} Value)

Sum({<Month_New={'Mar'}>} Amount)

In my Actual Application, the Expressions are very complex.

I just had shared the sample Application.

Hope you understood my question???

I have to Apply Logic only in the Calculated Dimension.

Calculated dimension:

=If(Aggr(Rank(-Sum({<Code={"=Sum(Amount)>=20"}>}Amount)),Code)<=3,Code,'Others')

Is there a way or any workaround.

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 18:39:39 GMT

I don't think this can be done without changing the expression. You might be able to make use of alternate state to get this done. Is alternate state an option?

Re: Front end Selection Working and Set Analysis not working

Wed, 28 Sep 2016 18:50:12 GMT

stalwar1‌

If we are using Sum(Amount)>=20 in Set Analysis in Calculated Dimension than why can't we use other condition for Max Month in set Analysis.

That's very strange behaviour or is there something Logical here which I am missing.

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 19:29:46 GMT

You bring up a good point, let me take a look at this

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 19:39:22 GMT

Sir you were right, try this:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code, Month_New)<=3,Code,'Others')

Thank you for pushing me to think it through

Re: Front end Selection Working and Set Analysis not working

sunny_talwar — Wed, 28 Sep 2016 19:41:59 GMT

Actually this:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code, Month_New)<=3,Code,If(Month_New = 'Mar', 'Others'))

Note: Check 'Suppress When Value Is Null'

Re: Front end Selection Working and Set Analysis not working

Thu, 06 Oct 2016 19:44:41 GMT

Thanks Sir.

I have followed both the Approach.

In the end, I found below approach better:

Calculated dimension:

=If(Aggr(Rank(-Sum({<Month_New={'Mar'},Code={"=Sum({<Month_New={'Mar'}>}Amount)>=20"}>}Amount)),Code)<=3,Code,'Others')

Expressions

Sum({<Month_New={'Mar'}>} Value)

Sum({<Month_New={'Mar'}>} Amount)

Regards

Cire