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: 
Not applicable

Set analysis - positive transactions from selected month

Hi,

please help me to write a script which show me only positive transaction quantities from selected month.

I don't know how to use AND in set analysis.

Below script which can show me sum of all transactions from selected month.

sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])

4 Replies
nathanfurby
Specialist
Specialist

If(

sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])>0,

sum ({$<Month = {"<=$(=Month)"}> [Recorded amount])

)

Depends on what dimension you have in the chart.  If you want to aggregate over a dimension not used in the chart then you will need to use the AGGR expression.

swarup_malli
Specialist
Specialist

NathanFurby,

that was perfect

Thanks

Swarup

rrsrini2907
Creator
Creator

Since you have set Analysis, you can try using like this

sum ({$<Month = {"<=$(=Month)"}>,[Recorded amount]={">0"}} [Recorded amount])

Regards,

Srini.

Not applicable
Author

Hi,

correct answer is:

sum({$<Month={"<=$(=Month)"}, [Recorded amount]={">0"}>} [Recorded amount])

Thanks!