topic Re: Set Analysis help in QlikView

Set Analysis help

samvile18 — Mon, 10 Dec 2012 15:48:30 GMT

Afternoon all,

Can someone help me with the following please?

I need some set analysis that will give me the sum of my FUM based on the MonthEnd of my date field.

My date field is called FExtractDate and it needs to sum everything that is the same as MonthEnd(MaxDate)

Thanks in advance guys.

MayilVahanan — Mon, 10 Dec 2012 18:47:55 GMT

Try

MonthEnd(FExtractDate) as dimension

sum(Sales) as Expression

Hope it helps

samvile18 — Tue, 11 Dec 2012 09:05:30 GMT

That's not applicable here as I've already got my dimensions set to something else, the syntax actually needs to be within the set analysis.

lironbaram — Tue, 11 Dec 2012 09:08:06 GMT

hi you can try

sum({<FExtractDate={"$(=MonthEnd(MaxDate))"}>}FUM)

let me know if it helps

samvile18 — Tue, 11 Dec 2012 10:29:00 GMT

Hi Liron,

Unfortunately I can't get that syntax to work 😞

lironbaram — Tue, 11 Dec 2012 11:58:06 GMT

could you post a sample data

with the fields you use with your expression

or a least your expression syntax