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

How to calculate previous day sales including GDN

Hi experts,

          I,m calculating sales including gdn for previous day using set analysis as

    

       {<tran_date={'$(=(max(tran_date)-1))'}>}

But m not getting value..Is this analysis is right??

Regards

2 Replies
pokassov
Specialist
Specialist

Hi!

  {<tran_date={'$(=date((max(tran_date)-1)))'}>}

Not applicable
Author

Hii

Actually it is not working bcoz max(tran_date) is showing some future date....But now I get the solution..actually I forget to add fact_type. Now it is working..

Thanks for your support.

Regards