topic Re: Use expression in set analysis in QlikView

Use expression in set analysis

Fri, 23 Mar 2012 17:06:46 GMT

In a Text Box I have this expression that gives me (what i believe to be) the numeric value for the previous month

=num(month(min(flow_date)-1)))

If I hard code the {2} the straight table shows the avg value...

=(Sum( {$<flow_month={2}, flow_day={">=1<=31"}>} numeric_value_1) - Sum( {$<flow_month={2}, flow_day={">=1<=31"}>} numeric_value_2)) / count({$<flow_month={2}, flow_day={">=1<=31"}>} flow_date)

so... can how would I replace the {2} with the expression from the text box?

thanks,

James

Re: Use expression in set analysis

jykang0638 — Fri, 23 Mar 2012 17:29:47 GMT

Hi James,

You can use $ sign expansion syntax at the set analysis like this:
Sum( {$<flow_month={"$(=month(min(flow_date)-1))"}, flow_day={">=1<=31"}>} numeric_value_1)

I hope it will help you.

Steve Kang

Use expression in set analysis

Fri, 23 Mar 2012 17:41:59 GMT

Steve,

Thanks. I tried many variations, but yours led to the correct answer.

Note: I added the num() back into the expression. Something about my flow_month is a numeric value which did not match the result of month()

James