Discussion Board for collaboration on QlikView Scripting.
I need to return 2 expression in one if condition.
if(vVariable = 'Yes', Only(A) and Only(B), if(vVariable='No', Only(C) and Only(D)))
A and B or C and D will be show like a bar in the same chart.
Thanks for replay
Go to Solution.
No, this is one chart that dynamically changes almost everything when you press a different button at the top.
Indeed, the addition with other amounts will follow the same logic.
If you're not using a PE Desktop, you can use the document in attachment to figure out how these screenshots were made.
could u share any sample data
What exactly you trying to do?
You can turn any amount of expression conditionally, but depends what you mean if this would apply or not.
Maybe I can't because I have just trial Version. I try to be more clarify.
I have 5 expression A B C D E.
If (myVariable=1, Only(A) and Sum(B), if(myVariable=2, Only(C) and Only (D), Sum(E)))
The format of expression look good, but dosn't work
I would to have this solution and use just one bar chart. The dimension is always the same.
I don't know, maybe there is another solution to show 2 expression with a define condition.
Could you share sample data ?
And also explain little bit more.
I want use one bar char that change the expression inside when change the variable selected.
I have this two chart and the variable that I use are the boton up (Mwh, Revenue, Opex etc)
I would like have just the first chart, that change dynamically the expression inside.
If MWh is selected my expression will be Production and P50 Product; if I select the variable Revenue, my expression should change in Revenue and Revenue BGT.
I need to insert some condition in expression that return me two condition.
I hope that is more easy to understand in this way
If condition is true, you have x and y. Do you want them to be added ?
Yes, where x e y are 2 Expression
Exactly i don't no ,but may be helpful for you
load * inline [
When click a in dim
when click b in dim
If you want to conacatenate output of two expression
then try like
If (myVariable=1, Only(A) &' : ' & Sum(B), if(myVariable=2, Only(C) & ' : ' & Only (D), Sum(E)))