Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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!