topic Re: Error when using variables in set analysis ? in QlikView

Error when using variables in set analysis ?

Anonymous — Fri, 25 Jan 2013 21:41:24 GMT

Hi,

I've decalred a variable in the frontend which picks up the current year

V_CurrentYear which contains the formula max(year)

though in the text box when tested it gives me the correct value ..ie 2013

but when used in an expression ..doesn't give any value (gives 0 as value which is wrong)

sum({<REPORT_DATE=V_CurrentYear>}CD_count)

Could some one correct my mistake

Fri, 25 Jan 2013 21:57:08 GMT

Try

sum({<REPORT_DATE={"$(V_CurrentYear)"}>}CD_count)

Fri, 25 Jan 2013 22:02:22 GMT

Try:

sum({<REPORT_DATE={$(V_CurrentYear)}>}CD_count)

Anonymous — Fri, 25 Jan 2013 22:15:59 GMT

Thank you Becca and Juan ..both the solutions work ..:)