Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sbkumar
Creator
Creator

set analsys

when i am practising set analysis i found some difficulty  in writing the expression.please can anyone help me in getting solution for my doubts

Top 10 Records

Bottom 10 Records

Current Year Vs Previous Year

Current Month Vs Previous Month

Last 5 Years Records

Last 6 Months Records

Last 4 Quarters Records

Current Quarter Vs Last Year Same Quarter

Current Month Vs Last Year Same Month

8 Replies
HirisH_V7
Master
Master

Hi ,

Check these links ,

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Re: Bottom 5 values

Better Go one by one, and search for better understanding.

HTH,

hirish

HirisH
“Aspire to Inspire before we Expire!”
prma7799
Master III
Master III

Hi Shiva,

If you get answer please close this thread.

Thanks

prma7799
Master III
Master III

Try like this

Current Year and Current Month Exp:

sum({$<Year={$(=Max(Year))},Month={ "<=$(max({<Year={$(=Max(Year))}>} Month))>$(Max({<Year={$(=Max(Year))}>}Month)-1)"}>}

Last Year and Current Month Exp:

sum({$<Year={$(=Max(Year-1))},Month={"<=$(Max({<Year={$(=Max(Year))}>}Month))>$(Max({<Year={$(Max(Year))}>}Month)-1)"}>}

---------------------------

For  Current Year :

Sum({<year= {$(=max(Year))}>}Sales)

For Previous Year :

Sum({<Year= {$(= max(Year-1))}>}Sales)

sbkumar
Creator
Creator
Author

i got the answer..but i dont know how to close the thread.

prma7799
Master III
Master III

Mark it correct ...

corrct.png

sbkumar
Creator
Creator
Author

no actions.PNG

prma7799
Master III
Master III

Not there you will get this option at below on  left hand side you no need to reply that just check left hand corner side.