topic Re: Combo Chart Expression % Change in QlikView

Combo Chart Expression % Change

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

I'm having issues with my line chart expression. I'm trying to create a % change from month to month but my percentages are incorrect. If someone can help, great. But could you also explain to me what I'm doing incorrectly? Thanks.

I want to see the % change from month to month and my values are incorrect.

Re: Combo Chart Expression % Change

sunny_talwar — Thu, 18 Aug 2016 17:15:32 GMT

What are the numbers you are expecting to see John?

Re: Combo Chart Expression % Change

Anonymous — Thu, 18 Aug 2016 17:21:45 GMT

For the line chart, % Change from month to month. All other values are correct.

201608 would be 5.6% decrease The difference between 54,087 and 51,061

201607 would be 7.2% decrease. The difference between 58,280 and 54,087

Re: Combo Chart Expression % Change

sunny_talwar — Thu, 18 Aug 2016 17:24:46 GMT

Try this:

If(RowNo() <= 6, Num(Count({<[Start Date Month] = {"*201*"} >} Member)

Below(Count({<[Start Date Month] = {"*201*"} >} Member), 1) - 1, '#.00%'))