Solved: Month wise sales with last year information - Qlik Community

vikasmahajan · ‎2012-09-24

Dear All,

Required folloing type of report

--------------------------------------------------------------------------------------------------------------------------

product Apr May Jun ----------------------------------------------------- March total Lys Qty

-------------------------------------------------------------------------------------------------------------------------

abc 100 200 300 600 700

Base on finacial year selected

Please help to build expressions.

Thanks in advance

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2012-09-24

Sum({$<Month={'Apr'}>} Qty) for each month will show only data for that month for year(s) selected. You may need to adjust date format for your purposes.

View solution in original post

Report Inappropriate Content · ‎2012-09-24

Sum({$<Month={'Apr'}>} Qty) for each month will show only data for that month for year(s) selected. You may need to adjust date format for your purposes.

vikasmahajan · ‎2012-09-25

Thanks

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.