topic Set analysis - positive transactions from selected month in QlikView

Set analysis - positive transactions from selected month

Thu, 03 Nov 2011 14:51:31 GMT

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])

Re: Set analysis - positive transactions from selected month

nathanfurby — Thu, 03 Nov 2011 16:54:24 GMT

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.

Set analysis - positive transactions from selected month

swarup_malli — Thu, 03 Nov 2011 17:20:00 GMT

NathanFurby,

that was perfect

Thanks

Swarup

Re: Set analysis - positive transactions from selected month

rrsrini2907 — Thu, 03 Nov 2011 17:37:42 GMT

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

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

Regards,

Srini.

Re: Set analysis - positive transactions from selected month

Fri, 04 Nov 2011 08:08:03 GMT

Hi,

correct answer is:

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

Thanks!