topic Re: Ignoring dimension with set analysis in QlikView

Ignoring dimension with set analysis

nsm1234567 — Wed, 04 Nov 2015 10:27:32 GMT

Hey There,

I'm battling to accomplish something and I'm wondering if someone can assist. What I'm looking for is a chart that looks like the below. The dataset I'm starting with is in the attached. Is it possible to have the chart in the attached look like the below? Any help would be greatly appreciated.

Brand	Date	Last Year Total	This Year Total
		30498261	38101086
Company1	10/10/2015	30498261	38101086

Re: Ignoring dimension with set analysis

Anonymous — Wed, 04 Nov 2015 10:42:35 GMT

in both of your Expression use aggr around

=aggr(sum(if(TransDateNo=vYesterday,Sales)),Brand)

Re: Ignoring dimension with set analysis

nsm1234567 — Thu, 05 Nov 2015 06:04:25 GMT

Hey There,

Thanks for the response. This works for the specific case I've put forward, but if I were to add more dates the "this year" wouldn't line up with "last year." What I'm going for is a list of dates with the two columns: The total for the specific date, and the total for the "last year" date.

Re: Ignoring dimension with set analysis

Anonymous — Thu, 05 Nov 2015 11:26:13 GMT

you should use a master calendar,

i made you a small example with your data (no complete mastercalendar)

look at the attached app

you need to select the year in the yearlistbox (select 2015 and you get both values)

if you only have two years you may adapt this solution