Set analysis failing when dimensions are removed

[#1]

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.

[swuehl]

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

Just try

=sum(Hours*Rate)

[#3]

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

[swuehl · Accepted solution]

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

[#5]

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

[swuehl]

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)

[#7]

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