topic Re: current vs previous vs same period last year in QlikView

current vs previous vs same period last year

singhcv123 — Tue, 06 Sep 2016 01:58:29 GMT

I have a requirement and for that i have a table .....

KPI

-----------

FInancial Year

Period code

Count

Booking

Now as per table i want 3 expression

(1) Current period ---that is just the value of field Count for selected Period COde

(2) Previous period- please suggest

sum({<Period code ={Num(Period Code)-1)}>}Count) ///but not working ...

(3) Same period last year ---please suggest how to generate a set expression for the same....

please suggest....

trdandamudi — Tue, 06 Sep 2016 02:05:04 GMT

It will be very helpful to test if you can share a sample file with expected output:

1) Not Clear

2) Sum({<Period code ={'[Period Code]-1'}>} Count)

3) Need more details

singhcv123 — Tue, 06 Sep 2016 02:17:19 GMT

HI PFA attached QVW fiLE AND PLEASE suggest the right set expression.......

trdandamudi — Tue, 06 Sep 2016 02:44:46 GMT

See if the below is helpful, if not can you please post the expected output:

1) =Count(Count)

2) =Sum({<[Period code] ={'[Period Code]-1'}>} Count)

3) =Sum({<[Financial Year] ={'=[Financial Year]-1'}>} Count)

singhcv123 — Tue, 06 Sep 2016 03:35:45 GMT

not getting desired outcome by applying this....