Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hello,
When you are creating the dimension you have a statement that is like:
=If([Estado] = "Cerrado", [Estado])
Regards,
Jeff
Thanks a lot, I use count(if(([Estado])='closed',[Estado])), and it works.
Thanks for you response.