Need help for a Logic

Anonymous — Tue, 22 Nov 2016 20:33:20 GMT

Hi,

I have a requirement which is little tricky.

I have to calculate a value (Sum(Sale))for the first month (January) of the calendar year and then populate the same value (calculated for Jan) for the rest of the year in a chart (Month as dimension) . Can someone please help me in how to do that?

Example for Jan it is 300, then for Feb to Dec it is 300 and show it in a chart. Month as dimension and the sum(sale) which is 300 as expression. How can we do this?

Thanks.

Re: Need help for a Logic

swuehl — Tue, 22 Nov 2016 21:03:35 GMT

Maybe use Month as dimension and

=Sum({<Month = {'Jan'}>} TOTAL sale)

as expression

Re: Need help for a Logic

Anonymous — Tue, 22 Nov 2016 21:43:24 GMT

Thank you so much Stefan. That worked

topic Re: Need help for a Logic in QlikView

Need help for a Logic

Re: Need help for a Logic

Re: Need help for a Logic