Make a Chart with a Condition

[#1]

Hi Everybody

I am new with qlikview, and i have a question, i want to make a chart with a condition, for example, in my DB i got a column call "Estado" and i want to make a Chart that shows only the summary by day that contains the word "Cerrado" into the column "Estado", i dont know how to make the expression to do that.

Sorry for my english.

Best Regards

[erichshiino · Accepted solution]

Hi, Kramelot

In this case, you need set analysis to create a sub-set of your data to the expression.

Let`s say that you have the expression SUM( VALUE).

The expression with set analysis will be SUM ( {<Estado = {'Cerrado'}>} VALUE)

Hope this helps,

Erich

[#3]

Hello,

When you are creating the dimension you have a statement that is like:

=If([Estado] = "Cerrado", [Estado])

Regards,
Jeff

[#4]

Thanks a lot, I use count(if(([Estado])='closed',[Estado])), and it works.

Thanks for you response.