topic Formula problem in QlikView

Formula problem

Tue, 22 Jan 2013 10:21:16 GMT

Hi all

Can somebody explain why this formula is not working?

=sum({$ < Fakten.Kostenart = {4207, if(vDatumVon <= '31.03.2012', '6662',Null)}, Kalender_Datum = {"$(='<='&(vDatumBis)&'>='&(vDatumVon))"} >} Fakten.Betrag )

When I replace "if(vDatumVon <= '31.03.2012', '6662',Null)" with a variable "vtest" it works perfectly.

sum({$ < Fakten.Kostenart = {4207, vtest}, Kalender_Datum = {"$(='<='&(vDatumBis)&'>='&(vDatumVon))"} >} Fakten.Betrag )

I've no idea why?

cheers

Marco

Re: Formula problem

Tue, 22 Jan 2013 10:30:26 GMT

Hi,

you can not use expressions directly in set anlysis.

so use:

$(=if(vDatumVon <= '31.03.2012', '6662',Null))

for

"if(vDatumVon <= '31.03.2012', '6662',Null)"

hope it helps u.

Niranjan M.

Re: Formula problem

Tue, 22 Jan 2013 10:32:15 GMT

Cool, works perfectly. Thank you. You made my day