Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Make a Chart with a Condition

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

Tags (2)
1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Make a Chart with a Condition

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 Replies
erich_shiino
Honored Contributor

Make a Chart with a Condition

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

Not applicable

Re: Make a Chart with a Condition

Hello,

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

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


Regards,
Jeff

Not applicable

Make a Chart with a Condition

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

Thanks for you response.

Community Browser