topic Re: Need to display data comparing two years sales in QlikView

Need to display data comparing two years sales

Fri, 28 Jun 2013 15:29:51 GMT

I have data for two years Sales ..

I need to display them in a single graph(Line graph) to compare this year sales with last year sales..

The current year has not ended, it has few more months left

I used Set Analysis,the following expressions used as in User manual.it does not yield the desired output i expected

=Sum({$<Year={$(=Only(Year))}>} [Sales Amount]) - Sum({$<Year={$(=Only(Year)-1)}>} [Sales Amount])

Attaching the graph which i get while using this expression & the desired output

Any help is appreciated in resolving this..

Regards

Gysbert_Wassenaar — Fri, 28 Jun 2013 17:05:05 GMT

Works for me. See attached example.

nizamsha — Fri, 28 Jun 2013 17:15:26 GMT

sum({$<year={"$(=only(year))"}>}sales) //current year

sum({$<year={"$(=only(year)-1)"}>}sales) //last year

sum({$<year={"$(=only(year))"}>}sales)-sum({$<year={"$(=only(year)-1)"}>}sales) //difference between the year

nirav_bhimani — Fri, 28 Jun 2013 17:16:58 GMT

Hi,

If you want to compare the value of current year till current month then used the following expression.

FISCAL_MONTHNum is Months in numeric

Sum({$<YEAR = {"$(=Max(YEAR ))"}, FISCAL_MONTHNum={"<$(=num(Month(Today())))"}>} [Sales Amount])

Sum({$<YEAR = {"$(=Max(YEAR )-1)"}>} [Sales Amount])

Regards,

Nirav Bhimani

Tue, 24 Sep 2013 09:37:16 GMT

Tried out with the same it displays "No data to display"

Any help is appreciated in this regard..

Tue, 24 Sep 2013 12:59:58 GMT

Why do you use Set analysis ?

You can use Year as dimension (or calculated dimension to display only last 2) and Month as dimension as well

Amount will be displayed along all the months from jan to dec

best regards

Chris