topic Re: SETANALYSIS on formula based on variable in QlikView

SETANALYSIS on formula based on variable

Mon, 02 Dec 2013 11:41:29 GMT

Hello,

I'm trying to search the expression to make a setanalysis with variable.

Something like this :

=sum(

{$<

[aDate] = {"makedate(year(vDate),month(vDate),day(vDate))"}

sales

)

please,

thank you.

Mon, 02 Dec 2013 11:46:33 GMT

Hi,

Did you tried like this?

sum(

{$<

[aDate] = {"$(=makedate(year(vDate),month(vDate),day(vDate)))"}

sales

)

Mon, 02 Dec 2013 12:40:06 GMT

Perfect, it works, thank you.