topic Re: Chart: How to set a data filter in QlikView

Chart: How to set a data filter

Thu, 20 Feb 2014 15:06:16 GMT

Hi all,

I have a bar chart where the X axis dimension is MonthNum (months from 1 to 12) taken from table A.

On this chart I'd like to count the CUSTOMER occurrences per month as reported in a different table B. In this table the month field is named MonthOpen.

I've set the expression for the bar chart as:

Count({<MonthOpen=MonthNum>} CUSTOMER)

but I get an error.

What's the right syntax to solve this problem?

Thank you.

Re: Chart: How to set a data filter

jpapador — Thu, 20 Feb 2014 15:09:08 GMT

try this:

Count({$<MonthOpen=P(MonthNum)>} CUSTOMER)

Alternatively you could rename the MonthOpen field in the script to MonthNum and it would create a join and you would not need to use set analysis.

Re: Chart: How to set a data filter

maxgro — Thu, 20 Feb 2014 15:18:07 GMT

or perhaps also this

Count(if(MonthOpen=MonthNum, CUSTOMER))

Re: Chart: How to set a data filter

Thu, 20 Feb 2014 15:33:05 GMT

Grazie, funziona perfettamente