topic Re: Help with set analysis in QlikView

Help with set analysis

Thu, 07 May 2015 13:51:20 GMT

I am trying to compute a sum to put in the denominator of a chart expression. This is what it looks like:

(sum(total if((STATUS <> 'X' and STATUS <> 'C') and (TYPE = 'COMM MTGE' or TYPE = 'CONST' or TYPE = 'CONST/PERM'), BALANCE)))

The problem that I am having is that I do not want this number to change if I make any selections on the document except for date selection. Is there a way to replicate this denominator expression but in a way that prevents it from being narrowed down by the current selections of the document? Kind of like a static number that only changes based on the date that I have selected.

Thank you!

Re: Help with set analysis

Clever_Anjos — Thu, 07 May 2015 13:58:25 GMT

Please try this

SUM(TOTAL {<STATUS-={'X','C'},TYPE={'COMM MTGE' , 'CONST' , 'CONST/PERM'}>}BALANCE)

Re: Help with set analysis

sunny_talwar — Thu, 07 May 2015 14:00:40 GMT

When you don't want something to change on a selection you use {1}

So something might this work:

(sum({1}total if((STATUS <> 'X' and STATUS <> 'C') and (TYPE = 'COMM MTGE' or TYPE = 'CONST' or TYPE = 'CONST/PERM'), BALANCE)))

Re: Help with set analysis

sunny_talwar — Thu, 07 May 2015 14:04:51 GMT

I guess it does need to be changed based on a selection in date. If that's true than you can use something like this:

(sum({1<Date = p(Date)>}total if((STATUS <> 'X' and STATUS <> 'C') and (TYPE = 'COMM MTGE' or TYPE = 'CONST' or TYPE = 'CONST/PERM'), BALANCE)))