topic Re: Set analysis formula in QlikView

Set analysis formula

Sat, 19 Oct 2013 14:01:22 GMT

hi i would like to combine a if statement and set analysis or rewrite the statement into set analysis.

SUM(if(Date2>=DateFrom and Date2<=DateTo,

{$<#Dat_O ={'1'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act))

at the moment i am experiencing syntax problems with this statement.

help is greatly appreciated.

Brad

jagan — Sat, 19 Oct 2013 14:46:43 GMT

Hi,

Is DateFrom and DateTo are variables? If yes, then use this

=Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)

If they are datefields, then try if there is any ID field then use this, replace ID with your ID Fieldname

=SUM(Aggr(if(Date2>=DateFrom and Date2<=DateTo and [#Dat_O] = 1, OrderRad.NettoBelopp * OH.Kurs_FSG_act), ID))

Regards,

Jagan.

preminqlik — Sat, 19 Oct 2013 15:51:52 GMT

according to your expression try this

SUM({$<#Dat_O ={'1'}>}if(Date2>=DateFrom and Date2<=DateTo,

OrderRad.NettoBelopp * OH.Kurs_FSG_act))

and also try this

Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'},Dat_O ={'1'}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)

preminqlik — Sat, 19 Oct 2013 15:56:05 GMT

if your DAt_O is in number then use this

Sum({<Date2={'>=$(=DateFrom)<=$(=DateTo)'},Dat_O ={1}>} OrderRad.NettoBelopp * OH.Kurs_FSG_act)