Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Freezing the selections

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.

2015.png

2016.png

Expected Output:

3-29-2016 6-09-04 PM.png

Thanks,

Rajitha

swuehlsunindia

1 Solution

Accepted Solutions
sunny_talwar

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>}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)

View solution in original post

11 Replies
swuehl
MVP
MVP

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)

sunny_talwar

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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...

sunny_talwar

Check now

Anonymous
Not applicable
Author

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.

sunny_talwar

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)

Anonymous
Not applicable
Author

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

sunny_talwar

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>}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)