topic Re: Calculation in a chart in QlikView

Calculation in a chart

Mon, 09 Mar 2015 12:21:47 GMT

Hello,

I would like to cound customernumbers that meet certain criterias.

I will Count all customernumbers where the customer has sum(DebPris)>30000

and where the sum is bigger this month than the previous mont. It´s the part I

have marked with bold text I cannot get running.

count({$<$(vSetMTD),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"},

{Sum({$<$(vSetMTD),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"}>} [DebPris]) >

Sum({$<$(vSetPreviousMonth),[Segment]={"Glas"},[KundNr]={"=Sum([DebPris])>=30000"}>} [DebPris])}

>} Distinct(KundNr))

kindly

Håkan

Re: Calculation in a chart

chrislofthouse — Mon, 09 Mar 2015 12:57:33 GMT

If possible the simplest and most efficient method would be to create flags for each of these requirements in the script. Then reference them in the Set Analysis.

Can you upload a sample app?

Re: Calculation in a chart

Mon, 09 Mar 2015 13:34:15 GMT

Here comes an test app

Håkan

Re: Calculation in a chart

chrislofthouse — Mon, 09 Mar 2015 13:43:28 GMT

I believe it can be achieved in the charts as follows:

if(Sum({$<$(vSetMTD),[Segment]={"Glas"}>} [DebPris]) > 30000 AND Sum({$<$(vSetMTD),[Segment]={"Glas"}>} [DebPris])>Sum({$<$(vSetPreviousMonth),[Segment]={"Glas"}>} [DebPris]),count({$<$(vSetMTD),[Segment]={"Glas"}>} Distinct KundNr))