topic Re: Set Analysis Locked the selection in QlikView

Set Analysis Locked the selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a question.

I have a chart with expression like this :

sum({<REGION={'A'}>}QTY)

i have a list box that contains region's value, let's say i have two values, REGION "A" and REGION "B"

When i choose REGION "B", the chart still shown, bcs i'm using the set analysis {<REGION={'A'}>}

Is it possible, if i choose Region B, the chart will shown "No Data Display" ?

Really sorry if my statement is not clear.

Thanks in advance

Re: Set Analysis Locked the selection

swuehl — Tue, 27 Sep 2016 06:44:17 GMT

Try the intersection operator:

sum({<REGION *= {'A'}>}QTY)

Re: Set Analysis Locked the selection

Anonymous — Tue, 27 Sep 2016 06:48:24 GMT

Hi Stefan,

Really thanks, you're my savior !

It solved my problem perfectly.

Thanks in advance.

Re: Set Analysis Locked the selection

Tue, 27 Sep 2016 06:53:51 GMT

hi Stefan ,

The expression which you given is nothing but to show only REGION A Sales Wright, If not it need to show no data is available.

I think for this we can also try with a if condition.

Re: Set Analysis Locked the selection

Tue, 27 Sep 2016 06:58:19 GMT

Hi,

Try this in your chart under General tab in Calculated condition give if(getfieldelections(REGION)='B',0,1)

And if you want to display 'No Data Display' in the chart give the Error messages(Button shown below the chart icons) as No Data Display corresponding to Calculating condition unfulfilled .

Hope this is helpful.

Regards,

Balakrishnan.R