topic Re: Set Analysis - Replace a known with a variable in QlikView

Set Analysis - Replace a known with a variable

jcharles — Fri, 04 Jul 2014 12:28:41 GMT

Good day

I have the following set analysis that works:

COUNT({$<[REPORTED MONTH]={"Jul 2014"}>CASEID)

I have a variable that is as follows:

vCurrentMonth =Monthname(today())

I want to replace "Jul 2014" with vCurrentMonth but when I do then the table shows no figures.

Please help.

alexandros17 — Fri, 04 Jul 2014 12:32:59 GMT

The sysntax is this:

COUNT({$<[REPORTED MONTH]={$(vCurrentMonth)}>CASEID)

but I think it will not work because you need a format MMM YYYY while Monthname(today()) returns MMM

Insert the variable in a text box and verify its value

Let me know

hic — Fri, 04 Jul 2014 12:33:25 GMT

There are many things that can go wrong here, but the following should work:

Make sure that [REPORTED MONTH] is a dual field - created with MonthName() in the script.
Use Count({$<[REPORTED MONTH]={'$(vCurrentMonth)'}> CASEID)

HIC

jcharles — Fri, 04 Jul 2014 13:12:39 GMT

Thank you