topic Re: Set analysis failing when dimensions are removed in QlikView

Set analysis failing when dimensions are removed

Mon, 05 Oct 2015 21:59:00 GMT

Please see the attached qlikview file. Its a very simple example and I want to correct my expression in scenario 2 to match scenario 1 (70 ) except i don't want the Name column. Can someone please help me ?

My end objective is to have 70 in a text box and I need to use set analysis.

Re: Set analysis failing when dimensions are removed

swuehl — Mon, 05 Oct 2015 22:17:25 GMT

It doesn't seem to be a set analysis issue.

Just try

=sum(Hours*Rate)

Re: Set analysis failing when dimensions are removed

Mon, 05 Oct 2015 22:23:49 GMT

I need to use set analysis because I have others filters applied which I haven't mentioned here for sake of simplicity. Like this date filter for example.

sum({$< [Date]= {"<$(=$(vMaxDate))"} >} [Hours] ) * Rate

Re: Set analysis failing when dimensions are removed

swuehl — Mon, 05 Oct 2015 22:53:00 GMT

Ok, then just add your set expression to the sum of Hours*Rate

Re: Set analysis failing when dimensions are removed

Tue, 06 Oct 2015 14:49:37 GMT

It ain't working Swuehl. Is there a way to modify the current expression ?

Re: Set analysis failing when dimensions are removed

swuehl — Tue, 06 Oct 2015 15:03:14 GMT

It's working for me given your sample data set:

=sum({$} Hours * Rate)

The set expression {$<>} doesn't make sense, and

{$< [Date]= {"<$(=$(vMaxDate))"} >}

can't be used in your sample application (no Date field).

So, if you are saying, it doesn't work for you, you need to

a) upload a new sample with a setting that is closer to your real setting (e.g. having Date field)

b) exactely tell what you are expecting to get when using something like

=sum({$< [Date]= {"<$(=$(vMaxDate))"} >} [Hours] * Rate)

Re: Set analysis failing when dimensions are removed

Tue, 06 Oct 2015 15:06:15 GMT

I understand. I am working on updating the sample data.