topic Re: Set Analysis syntax in QlikView

Set Analysis syntax

samvile18 — Fri, 02 Dec 2011 15:57:15 GMT

I swear this is possible but I can't quite get the syntax

I have the following set analysis that shows me data for all our active history FTE where the ExtractDate is the same as the UploadDate:

sum({<Measure={'ActiveHistory'},ExtractDate={'$(=max({<KPI={'FTE'}>} UploadDate))'}>} FTE)

What I need to do is add the following to it:

Count({<Measure={'Vacancies'},ExtractDate={'$(=max({<KPI={'Vacancies'}>} UploadDate))'}>} Measure)

The reason is because at the moment these two are separate expressions, I only want the one.

Is this possible?

Any help is appreciated.

Re: Set Analysis syntax

Mon, 05 Dec 2011 05:35:10 GMT

Hi Sam,

First things first. Your set analysis is wrong in both expressions.

Use the following.

sum({<Measure={'ActiveHistory'},ExtractDate={"$(=max({<KPI={'FTE'}>} UploadDate))"}>} FTE)

and

Count({<Measure={'Vacancies'},ExtractDate={"$(=max({<KPI={'Vacancies'}>} UploadDate))"}>} Measure)

Secondly, how do you want to use the sexond expression? Do you want to integrate the second expression in the set analysis part of the first expression?

Do clarify,

BR,

Abhi

Re: Set Analysis syntax

samvile18 — Mon, 05 Dec 2011 09:28:52 GMT

Hi Abhi,

Thanks for the reply. To be honest it doesn't really make much difference, two separate syntax strings will be fine.

Thanks for the help