topic Re: How to plot full value even i filter certain data. in QlikView

How to plot full value even i filter certain data.

Wed, 19 Feb 2014 13:55:24 GMT

Hi All

When i filter brand = BEC

How can i prevent my line chart not affected ?

Paul

Re: How to plot full value even i filter certain data.

Wed, 19 Feb 2014 13:56:53 GMT

Hi All

I mean how to modify the expression , so that it will ignore user selection. Just like SET analysis , even i select month = jan , it will still display all date sales.

Paul

Re: How to plot full value even i filter certain data.

Wed, 19 Feb 2014 14:05:15 GMT

Detach, If you want the chart to not change at all. (Right click on chart and Detach)

Re: How to plot full value even i filter certain data.

Wed, 19 Feb 2014 14:32:19 GMT

Hi Sir

Any other alternative , as your suggestion is not suitable for me.

Paul

Re: How to plot full value even i filter certain data.

Nicole-Smith — Wed, 19 Feb 2014 14:34:18 GMT

Your original expression:

money(

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK))

You can ignore selections in specific fields by adding them into the set analysis with just Field= (see Brand below):

money(

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, Brand=>}$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK))

You can ignore all selections by using a 1 in the set analysis instead of the $:

money(

sum({1<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK))

You can also ignore all selections by giving the chart a different alternate state than the rest of the document.

Re: How to plot full value even i filter certain data.

Wed, 19 Feb 2014 14:48:40 GMT

Hi Paul,

check out my suggestion.

Greetings

Roland

Re: Re: How to plot full value even i filter certain data.

Wed, 19 Feb 2014 23:44:40 GMT

Hi Sir

Now i like to learn from you how to add one more field in the expression. So that when user click on GROUP_CLASS field label , it will not affect the chart.

Re: Re: Re: How to plot full value even i filter certain data.

Thu, 20 Feb 2014 00:33:04 GMT

Hi Paul,

normally this (new) part of SET Analysis of your expression would do the job:

. . . . $<BRAND_ =, GROUP_CLASS=, . . ..

But as you can see, for some reasons month is undefined for GROUP_CLASS= "G". So when your user selects "G" the expression becomes undefined (see arrow) and the chart has nothing to calculate.

Good Night

Roland