Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!