topic Re: Exclude selectjions in chart in QlikView

Exclude selectjions in chart

Anonymous — Mon, 21 Sep 2015 08:54:45 GMT

Hi All,

I have list box with all month value .Jan to Dec.

I have another object apha period in chart as dimension which contains combination of year and month 2015.01

my requiremnt is if i select Month list box it is corresponding corresponding alpha period value

for suppose if i select jan it is showing 201501

But i want to display all the alphaperiod value even if i select jan month .

Re: Exclude selectjions in chart

sunny_talwar — Mon, 21 Sep 2015 08:58:47 GMT

Are we talking about doing this in a list box? May be use an alternate state which doesn't impact any selection on the inherited state. or you can give this a try as well for your list box expression:

=Aggr(Only({<month = >}alphaperiod), alphaperiod)

Re: Exclude selectjions in chart

Anonymous — Mon, 21 Sep 2015 09:03:46 GMT

I have tried your expression but not working

Alphaperiod is used as dimension in chart

Re: Exclude selectjions in chart

simenkg — Mon, 21 Sep 2015 09:09:38 GMT

In your expression, add

[Month]= to the Set analysis part.

If you dont have a set analysis in the expression then the whole expression will become something like:

sum({<[Month]=>} Value)

Remember that field names are case sensitive

Re: Exclude selectjions in chart

sunny_talwar — Mon, 21 Sep 2015 09:10:40 GMT

Use this in your expressions:

{<month = >}

This will tell your expression (and dimension) that it should not change with selection in month listbox

Re: Exclude selectjions in chart

Anonymous — Mon, 21 Sep 2015 09:18:46 GMT

below is my set expr

i have added my monthname in the set epression but it is not working

=sum({<ANALYTICAL_CATEGORY={'PROFITLOSS'},PERIOD_YEAR=,PERIOD_ALPHA ={'<=$(vMaxPeriodAlpha)'},MONTHNAME=,MONTH_NAME=>}BUDGET)/FactorValue

Re: Exclude selectjions in chart

Anonymous — Mon, 21 Sep 2015 11:11:30 GMT

HI all,

I have added the below expression it is working

Sum({<MONTHNAME=>}1)

But if i made similar changes in the my set expression it is not getting exact result

MOdified set expression

=sum({<ANALYTICAL_CATEGORY={'PROFITLOSS'},PERIOD_YEAR=,PERIOD_ALPHA ={'<=$(vMaxPeriodAlpha)'},MONTHNAME=,MONTH_NAME=>}BUDGET)/FactorValue

Re: Exclude selectjions in chart

jonathandienst — Mon, 21 Sep 2015 11:15:39 GMT

How is vMaxPeriodAlpha defined? If you create a text object with =vMaxPeriodAlpha as the expression, do you get what you would expect?

As always, the best way to get accurate suggestions is for you to post a sample the shows the issue, together with what you expect as the results.

Re: Exclude selectjions in chart

Anonymous — Mon, 21 Sep 2015 11:27:37 GMT

HI i have figured out problem Thanks for your responses