topic Re: Value in Text Box in QlikView

Value in Text Box

mohammadkhatimi — Wed, 07 Sep 2016 06:05:15 GMT

HI,

We need Value3 in text box..

Logic is if Value1 is zero than pick Value2 else Value1..This is done in staright table but requirement is in textbox...

How to show plz help...!!!

Regards,

Mohammad

swuehl — Wed, 07 Sep 2016 06:18:39 GMT

Which value of column "Value3" do you want to show? An aggregated, summed value?

=Sum( If( Value1, Value1, Value2))

or maybe a concatenated string?

=Concat( If( Value1, Value1, Value2), ', ', OID)

mohammadkhatimi — Wed, 07 Sep 2016 06:40:05 GMT

I tried below logic but its not working.

Its showing only Value1 values not Value2

=Sum( If( Value1, Value1, Value2))

mohammadkhatimi — Wed, 07 Sep 2016 06:46:14 GMT

In above example which I shared its working but if I'm applying on my data than its not working..

Results comes only Value1

trdandamudi — Wed, 07 Sep 2016 06:58:24 GMT

Can you please share a small sample to test it out...