topic Re: Freezing the selections in QlikView

Freezing the selections

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

Hello every1,

I'm trying to freeze the Combo chart graph when I'm making selections in the Month and Year List box it should not change in the chart. Please find the attached qvw file and Screen shot.

Expected Output:

Thanks,

Rajitha

swuehl‌ sunindia‌

Re: Freezing the selections

swuehl — Tue, 29 Mar 2016 22:29:02 GMT

I can't see your QVW, but in general, you should be able to achieve what you want using set analsis.

Something like

=Sum({<Year =, Month = >} Value)

Re: Freezing the selections

sunny_talwar — Tue, 29 Mar 2016 22:37:24 GMT

I agree, can't see anything attached, but the usually ignore using {<Year, Month>} from all aggregation functions including Only

Re: Freezing the selections

Anonymous — Tue, 29 Mar 2016 23:45:39 GMT

Sorry I forgot to attach the file. PFA now...:)

Re: Freezing the selections

Anonymous — Tue, 29 Mar 2016 23:46:54 GMT

Bro the one which you sent me is changing when I'm making selections in the year and month. Please find the attached qvw file now...

Re: Freezing the selections

sunny_talwar — Tue, 29 Mar 2016 23:52:06 GMT

Check now

Re: Freezing the selections

Anonymous — Wed, 30 Mar 2016 00:02:41 GMT

Bro.. I'm trying to download the file but its getting failed. Could you please post the expressions, so that I'll copy into my dashboard.

Re: Freezing the selections

sunny_talwar — Wed, 30 Mar 2016 00:05:19 GMT

2016:

=SUM({<Year = {2016}, Month>}Aggr(IF(

SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)>= Only({<Year = {2016}, Month>}C_PtileBeg) and

SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)<= Only({<Year = {2016}, Month>}C_PtileEnd), Only({<Year = {2016}, Month>}C_Star)) * Only({<Year = {2016}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))

SUM({<Year = {2016}, Month>}Weight)

2015:

=SUM({<Year = {2015}>}Aggr(IF(

SUM({<Year = {2015}>}NUMERATOR)/SUM({<Year = {2015}>}DENOMINATOR)>= Only({<Year = {2015}>}C_PtileBeg) and

SUM({<Year = {2015}>}NUMERATOR)/SUM({<Year = {2015}>}DENOMINATOR)<= Only({<Year = {2015}>}C_PtileEnd), Only({<Year = {2015}>}C_Star)) * Only({<Year = {2015}>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))

SUM({<Year = {2015}>}Weight)

Re: Freezing the selections

Anonymous — Wed, 30 Mar 2016 00:11:27 GMT

Anna.... Its working fine when I'm making selections in the Year But when I'm selecting the Month the graph is changing...

Re: Freezing the selections

sunny_talwar — Wed, 30 Mar 2016 00:14:12 GMT

Forgot to ignore Month selection in 2015 expression. Try this for 2015

=SUM({<Year = {2015}, Month>}Aggr(IF(

SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)>= Only({<Year = {2015}, Month>}C_PtileBeg) and

SUM({<Year = {2015}, Month>}NUMERATOR)/SUM({<Year = {2015}, Month>}DENOMINATOR)<= Only({<Year = {2015}, Month>}C_PtileEnd), Only({<Year = {2015}, Month>}C_Star)) * Only({<Year = {2015}, Month>}Weight), C_Star,_CMS_ThresholdMeasureYearKey,Month))

SUM({<Year = {2015}, Month>}Weight)

2016 stays the same:

=SUM({<Year = {2016}, Month>}Aggr(IF(

SUM({<Year = {2016}, Month>}NUMERATOR)/SUM({<Year = {2016}, Month>}DENOMINATOR)>= Only({<Year = {2016}, Month>}C_PtileBeg) and

SUM({<Year = {2016}, Month>}Weight)

Re: Freezing the selections

Anonymous — Wed, 30 Mar 2016 00:18:54 GMT

Thank you so much bro.. Its working

Re: Freezing the selections

sunny_talwar — Wed, 30 Mar 2016 00:19:54 GMT

Great