topic Re: If statements with multiple conditions in QlikView

If statements with multiple conditions

Mon, 07 Oct 2013 16:21:45 GMT

I put this expression into a Text Object text expression box and says the Expression is Ok, but the correct image does not display based upon the Column2 value. I have the Image selected from the Representation drop down in the General tab.

Column1 has 8 different variables (A, B, C, D, etc) and Column2 has 1, 2, 3 which corresponds with the direction of the arrow.

=if(Column1='A' and Column2=1,'qmem://<bundled>/BuiltIn/arrow_n.png',

if(Column1='A' and Column2=2,'qmem://<bundled>/BuiltIn/arrow_e.png',

if(Column1='A' and Column2=3,'qmem://<bundled>/BuiltIn/arrow_s.png')))

Re: If statements with multiple conditions

Clever_Anjos — Mon, 07 Oct 2013 16:32:40 GMT

If you´re using a Text Object maybe you should use some sort of aggregation.

A text object does not provide a dimension so all values of Column1 and Column2 are evaluated so your expression will always return null

Re: If statements with multiple conditions

Mon, 07 Oct 2013 16:36:34 GMT

I put the expression in the Load statement then named it as Trend1 and made the expression to =Trend1. I did this for multiple trends with different numbers (directions) and it worked great!

Re: If statements with multiple conditions

Clever_Anjos — Mon, 07 Oct 2013 16:41:23 GMT

Could you post a qvw?