topic how to get previous day value in QlikView

how to get previous day value

ravindraa — Wed, 03 Dec 2014 10:37:27 GMT

Hi all,

I have struck in one place my requierment is we have to display the values

day wise if the selected day is sunday then we need to pick previous day(saturday).

i wrote expression like below

(weekdate_Orderdate='Sun',(Num(Count({<Type={'B'},Day={"$(=Day-1)"},B_ExecutionFlag={'1'}>} DISTINCt If([Execution Interval]<=V_FFR_U,[Sales Doc.],nULL()))
/Count({<Type={'B'},Day={"$(=Day-1)"}>}DISTINCT [Sales Doc.])*100 , '##.##')),

Num(Count({<Type={'B'}, B_ExecutionFlag={'1'}>} DISTINCt If([Execution Interval]<=V_FFR_U,[Sales Doc.],nULL()))
/Count({<Type={'B'}>}DISTINCT [Sales Doc.])*100 , '##.##')
)

please give me any suggesion on this.

Thanks in advance.

Re: how to get previous day value

ravindraa — Mon, 08 Dec 2014 07:42:43 GMT

Hi Experts,

I am sending sample data image find below the same.

above screen shot june 28 is Saturday it is giving exact value.

NM(Numarator)

DNM(Denaminator)

totalvalue(NM/DNM)

NM Exclude sunday= i mean it should be display the previous day if the selection is sunday.

if i select Sunday (June sundays-8,15,29) in NM exclude Sunday colum it is showing Zeros.

Actuvaluy above expression need to display the value selected day value, when the days is sunday it has to be display the Saturday value.

After select the Sunday it is showing Zero value please find the below screen shot.

Please give me any one suggesion on this.

Thanks in advance.