Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
singhcv123
Contributor
Contributor

current vs previous vs same period last year

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....

4 Replies
trdandamudi
Master II
Master II

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
Contributor
Contributor
Author

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

trdandamudi
Master II
Master II

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
Contributor
Contributor
Author

not getting desired outcome by applying this....