topic GetFieldSelections Yesterday in QlikView

GetFieldSelections Yesterday

Thu, 12 Apr 2012 09:37:24 GMT

Hi Guys

Im building a straight table chart where I wish to only have the data when Period_dte = Yesterday

Date is a demension and I have tried a calculated demension too and I cant quite get it to work

Has anyone got any advice please ?

Thanks

I have tried :

GetFieldSelections(Period_dte=date(today()-1)

But its not working

CELAMBARASAN — Thu, 12 Apr 2012 10:04:30 GMT

Hi,

Use calculated dimension as if(Period_dte=date(today()-1),Period_dte)

Its better to use set analysis instead of calculated dimension like below for the expression

Sum({<Period_dte={'$(=date(today()-1))'>} FieldName)

Celambarasan

Thu, 12 Apr 2012 10:20:03 GMT

Hi Celambarasan

I tweaked your answer and in the load statement put

IF(Period_dte = Today() - 1, 'Yes',null()) as

So I could then load as a demension and tick if Null() hide , so only yesterday info showed

Thanks for your help