Sum/count issue

sat_tok52 — Thu, 28 Jul 2016 12:04:56 GMT

Hi guru's,

I am comparing current year vs last year against region using bar chart ,when I select filter 2015 it working fine with percentage format in y-axis ,when i select filter 2016 it is not working ,the y-axis still apperas number format .Both expression i have checked percentage check box in number tab.When I remove denominator it's working both filter. Any help.

I am using below expression.

Sum( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)

(Count( {<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])

Sum( {<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)

Count( {<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])

--Sateesh

Re: Sum/count issue

Anonymous — Thu, 28 Jul 2016 12:49:31 GMT

Maybe you need to use the Set Analysis 1 for all records - as in ignore selections :

Sum( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} Amount)

(Count( {1<Date={">=$(vPriorYearStartDate) <=$(vPriorYearEndDate)"}>} [Account Name])

Sum( {1<Date={">=$(vCurrentYearStartDate) <=$(vCurrentYearToday)"}>} Amount)

Count( {1<Date={">=$(vCurrentStartDate) <=$(vCurrentYearToday)"}>} [Account Name])

topic Re: Sum/count issue in QlikView

Sum/count issue

Re: Sum/count issue