Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Valued Contributor

Re: Set analysis - positive transactions from selected month

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
Valued Contributor

Set analysis - positive transactions from selected month

NathanFurby,

that was perfect

Thanks

Swarup

Highlighted
rrsrini2907
Contributor

Re: Set analysis - positive transactions from selected month

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

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

Regards,

Srini.

Not applicable

Re: Set analysis - positive transactions from selected month

Hi,

correct answer is:

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

Thanks!