topic Re: is possible return 2 expression in one if condition? in QlikView

is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 07:31:45 GMT

I need to return 2 expression in one if condition.

i.e

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

Pasquale

Re: is possible return 2 expression in one if condition?

Thu, 26 Nov 2015 10:15:29 GMT

could u share any sample data

Re: is possible return 2 expression in one if condition?

Mark_Little — Thu, 26 Nov 2015 10:22:08 GMT

Hi,

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.

Mark

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 10:24:48 GMT

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.

Re: is possible return 2 expression in one if condition?

nagarjuna_kotha — Thu, 26 Nov 2015 10:34:18 GMT

Could you share sample data ?

And also explain little bit more.

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 10:56:37 GMT

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

Re: is possible return 2 expression in one if condition?

tresB — Thu, 26 Nov 2015 11:01:27 GMT

If condition is true, you have x and y. Do you want them to be added ?

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 11:13:24 GMT

Yes, where x e y are 2 Expression

Re: is possible return 2 expression in one if condition?

Thu, 26 Nov 2015 11:13:49 GMT

Hi Pasquale,

Exactly i don't no ,but may be helpful for you

sample:

load * inline [

dim,A,B,C,D,E

a,1,2,3,4,5

b,9,8,7,5,6

];

When click a in dim

when click b in dim

Re: is possible return 2 expression in one if condition?

PrashantSangle — Thu, 26 Nov 2015 11:14:47 GMT

Hi,

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)))

Regards

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 11:24:58 GMT

thanks for the reply. but can't works for me because it show in the legend all expression even if is not used in a chart. I thought about this but I need a find another way ..

Really thanks

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 11:32:38 GMT

Hi Max,

Yes I want concatenate two expression.

I tried this but doesn't work. the chart show me just one expression, that is a strange number (I don't know which kind of operation the tool do). I would like to show separate bar one for A and another for B.

Re: is possible return 2 expression in one if condition?

tresB — Thu, 26 Nov 2015 12:48:42 GMT

Try like:

If (myVariable=1, RangeSum(Only(A), Sum(B)), if(myVariable=2, RangeSum(Only(C), Only (D)), Sum(E)))

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 13:04:03 GMT

Hi ,

thanks for help me, but dosn' t work yet.

this is the result, I have just one bar (I would like separare bar), where the value is a strange number.

What u thinking about? Maybe you know a different way to do this?

Really thanks

Re: is possible return 2 expression in one if condition?

morganaaron — Thu, 26 Nov 2015 14:19:41 GMT

If you want two bars, you'll need two expressions. If they are interchangeable, just have one be Only(A) or Only(C) and the other be Only(B) or Only(D) - that way you'll have two bars, either A and B or C and D.

Re: is possible return 2 expression in one if condition?

Peter_Cammaert — Thu, 26 Nov 2015 15:08:50 GMT

Something like this? I only made it with two buttons. The others follow a similar logic, but you didn't specify what should be displayed when clicking for example 'Opex'.

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 15:23:09 GMT

Hi Peter,

but you used two different chart or just one? Regarding Opex I have other data but if I can do it for MWh and Revenue, I will do the same for other botton.

Re: is possible return 2 expression in one if condition?

Peter_Cammaert — Thu, 26 Nov 2015 16:34:58 GMT

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.

Best,

Peter

Re: is possible return 2 expression in one if condition?

pascos88 — Thu, 26 Nov 2015 16:43:01 GMT

It is just what I need. But I can't see the attach document. where is it?

Re: is possible return 2 expression in one if condition?

MarcoWedel — Fri, 27 Nov 2015 00:12:47 GMT

don't open this reply in your inbox but open the thread itself.

regards

Marco