Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jcharles
Contributor III
Contributor III

Set Analysis - Replace a known with a variable


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.

1 Solution

Accepted Solutions
Henric_Cronström

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

View solution in original post

3 Replies
alexandros17

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

Henric_Cronström

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

View solution in original post

jcharles
Contributor III
Contributor III
Author

Thank you