topic Make a Chart with a Condition in QlikView

Make a Chart with a Condition

Mon, 24 Oct 2011 16:21:09 GMT

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

Make a Chart with a Condition

erichshiino — Mon, 24 Oct 2011 17:34:55 GMT

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

Re: Make a Chart with a Condition

Mon, 24 Oct 2011 17:42:02 GMT

Hello,

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

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

Regards,
Jeff

Make a Chart with a Condition

Mon, 24 Oct 2011 21:39:02 GMT

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

Thanks for you response.