topic Re: Set Analysis in QlikView

Set Analysis

racer25 — Thu, 09 Apr 2015 11:12:52 GMT

Hi All,

I am trying to create some static charts that are unaffected by selection. From my limited knowledge of Set Analysis I believe that this is where I need to go?

I have a Speedometer with the formula

=num(sum(if(FLAG ='ENTRY',HOURSENTERED,0)) / sum(if(FLAG ='REQUIREMENT',HOURSENTERED,0)),'#,##%')

Essentially I am comparing time entered versus time required to be entered in the above.

What I would like to do also are a couple of other views restricting to certain data flags.

1. Where the Year is 2014

2. Where the Year is 2015 and the Quarter is Q1

3. Where the Year is 2015 and the Quarter is Q1 and the Department is Corporate

Year, Quarter and Department are all fields.

Its an area I really should practice more on and hopefully with a dig out from the Community I will have some relevant ( to me ) examples that I can take forward.

Thanks in advance,

Rob

Re: Set Analysis

Anonymous — Thu, 09 Apr 2015 11:17:38 GMT

=sum({<FLAG ={'ENTRY'},Year={'2014','2015'}>}HOURSENTERED) / sum({<FLAG ={'REQUIREMENT'},Year={'2014','2015'}>}HOURSENTERED)

Similarly you can add more conditions to it for quarter and Department.

Re: Set Analysis

racer25 — Thu, 09 Apr 2015 11:31:49 GMT

Many thanks works perfectly, also as its in my own data I have something that I can follow.

Much appreciated.

Re: Set Analysis

Anonymous — Thu, 09 Apr 2015 12:45:56 GMT

Great!!