topic Re: How to Achieve this in QlikView

How to Achieve this

alvinford — Fri, 10 Apr 2015 16:25:50 GMT

Hi ,

Request your help to achieve this.

I have the sales from Jan 2013 till 2015 Feb. Want to display the current sales and carried over sales in the Bar Chart with Dimension as Country.

if I am selecting the Year = 2015 and Month =Feb, My current sales should the sales for 2015 Feb and my carried over sales should be

from Jan 2013 till 2015 Jan

and in the same way if I am selecting the Year = 2014 and Month = Aug,My current sales should the sales for 2014 Aug

and my carried over sales should be from Jan 2013 till 2014 Jul.

How to achieve this using set analysis.

Regards,
Alvin.

MK_QSL — Fri, 10 Apr 2015 16:35:00 GMT

Look into below link... ..

Or provide sample data to work..

petter — Sun, 12 Apr 2015 10:38:31 GMT

Current Sales: Sum( Sales )

Carried over Sales: Sum( {<YearMonth={"<=$(=Max(YearMonth))"},Year=,Month=>} Sales )

The Year and Month has to be deselected (in blue above) as they would otherwise interfer with the selection of YearMonth.

Create a field in your load script like this:

Year( thisDate )*100 + Num( Month( thisDate ) ) AS YearMonth