Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harleen_singh
Creator III
Creator III

last 15 transaction dates and values in set analysis

Hi,

I am looking for last 15 transaction values available in table how to write in set analysis?

if Sales=0, than i do not want to consider it in 15 days. Only 15 days where some sales<>0 and Sales = null.

thanks

Harleen

5 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Could you share your data sample?

satheshreddy
Creator III
Creator III

Hi Harleen,

you can use the date functions in sets you will get last 15 transactions.

other wise use transaction id and find-out last five transactions.

Regards

Sathish

harleen_singh
Creator III
Creator III
Author

mindaugasbacius

Here is the data sample. in this sample you will not see any transaction on 10 and 11 may.

So last 15 day should not refelect 10 may and 11 may with 0 in chart.

I need a set statement for this

  

17/05/201715
16/05/201720
15/05/201725
14/05/201730
13/05/201735
12/05/201740
09/05/20170
08/05/201740
07/05/201725
06/05/201710
05/05/201710
04/05/201710
03/05/201710
02/05/201710
01/05/201710
Oliver_F
Partner - Creator III
Partner - Creator III

hi,

are you using an master calendar? Otherwise May 10th and 11th will not be shown as a zero bar in your barchart.

To filter 9th of may too, you can use this formular:

Sum(

  {$<

    amount = {"<>0"}

    >}

amount)

harleen_singh
Creator III
Creator III
Author

Here is the data sample. in this sample you will not see any transaction on 10 and 11 may.

So last 15 day should not refelect 10 may and 11 may with 0 in chart.

I need a set statement for this

 

17/05/201715
16/05/201720
15/05/201725
14/05/201730
13/05/201735
12/05/201740
09/05/20170
08/05/201740
07/05/201725
06/05/201710
05/05/201710
04/05/201710
03/05/201710
02/05/201710
01/05/201710