topic Re: Set analysis in QlikView

Set analysis

Tue, 31 Jul 2012 13:17:26 GMT

I have some table boxes. All of which I only want to display the current months totals.

Meaning where COMMAG.MONTH is equal to the current month. I only want the written premium, adjusted premium, etc. to display for that month.

daveamz — Tue, 31 Jul 2012 14:05:14 GMT

Hi,

First, create a variable like vDate=date(today(),'YYYYMM')

then, for written premium, ajusted premium etc. use the following expression:

sum({<COMMAG.MONTH={"$(vDate)"}>} written premium value)

Regards,

David

chematos — Tue, 31 Jul 2012 14:37:00 GMT

daveamz01 is right

In order to ignore other filters you could add TOTAL to the expression

sum({<COMMAG.MONTH={"$(vDate)"}>}TOTAL written premium value)

Regards

Tue, 31 Jul 2012 15:10:51 GMT

Thanks guys. I ended up doing it a different way.

if(COMMAG.Process_Month=month(today(1)),if(COMMAG.Process_Year=year(today(1)),COMMAG.Process_Month

))

As a calculated dimension. I then supressed nulls for the dimension and hid the calculation on the presentation tab.