Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vinay_bangari
Specialist III
Specialist III

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

vinay_bangari
Specialist III
Specialist III

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

vinay_bangari
Specialist III
Specialist III

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

vinay_bangari
Specialist III
Specialist III

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)

vinay_bangari
Specialist III
Specialist III

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)

View solution in original post