Compare with last year data...

Mon, 19 Oct 2015 20:11:36 GMT

Hello everyone,

I just started working with Qlikview and came across this tricky situation in which I have to compare data with last year's total figures and display right next to current year total amount. All selected filters should stay as it is and applies to last year total as well.

e.g. data looks something like this...

Program and Class are the filters

and Group1 and Group2 are part of the Inline Load i have to decide grouping in my chart table:

Program	Class	Group1	Group2	Year	Amount
PROG1	A	100	50	2016	100
PROG1	A	100	100	2015	200
PROG1	B	200	100	2016	500
PROG1	A	300	150	2015	400
PROG1	D	100	100	2015	450

If Program: Prog1, Class = 'A' and Group1 selected then,

My output should look like below..

Group1	Sales	LY_Sales
	100	100
100	100	100
300	400	0

I have attached sample file here..

Re: Compare with last year data...

Tue, 20 Oct 2015 00:31:11 GMT

Anybody!!!

Moderators!!

Re: Compare with last year data...

sumeet-vaidya — Tue, 20 Oct 2015 09:05:41 GMT

Hi Sambhaus,

Kindly find the below screenshot where you need to aggregate the expression on Groups.

Also, In Dimension use this Expression in Enable Condition ==> if($Field = 'Group1',1,0) for Group1

and if($Field = 'Group2',1,0) for Group2.

Hope this resolves your problem.

Regards

Sumeet

topic Compare with last year data... in QlikView

Compare with last year data...

Re: Compare with last year data...

Re: Compare with last year data...