topic Re: IF Function in QlikView

IF Function

Sat, 06 May 2017 21:36:06 GMT

Hi I am having trouble creating and if function to change the background colour of cost >= 5000 within this table could anyone please help me correct my formula.

hi, I was also wondering if it possible to create an if-function which generates a yes or no response based on whether a particular staff approved quantities greater than 3000 for the following table.

Thanks in advance.

Re: IF Function

vinieme12 — Sun, 07 May 2017 08:55:12 GMT

if (Cost > 5000 , red() )

is cost a dimension in your table or expression?

Re: IF Function

Sun, 07 May 2017 08:58:06 GMT

Cost is a measure made up of quantity*unit price

Re: IF Function

Anil_Babu_Samineni — Mon, 08 May 2017 04:52:42 GMT

Seems, You are working with Qliksense. There you need to write from Colors tab by using Measure. Then only it will give some output. Any how, Your expression seems okay. Would you tell us where do you copy and paste this expression.

PS: Still, you are not figure it out then please share QVF file with us

Re: IF Function

Anil_Babu_Samineni — Sat, 13 May 2017 01:15:14 GMT

Measure means, Does this data point or you created any variable by name of Color.

Re: IF Function

rubenmarin — Sat, 13 May 2017 07:59:26 GMT

Hi Shamila, in expression editor you can't use measures by name, you have to use the fields loaded in the app, I think the easiest way is to copy the content of the measure, like:

If(quantity*unit>5000, red())

I'm not fully understanding your second question. Maybe?:

If(sum(quantity)>3000, 'yes', 'no')

Re: IF Function

Sat, 13 May 2017 22:01:48 GMT

Hi guys, thanks for the help the first issue has been solved

Re: IF Function

Sat, 13 May 2017 22:03:31 GMT

The second question was could you generate an if function to create a new column which says yes or no if payments greater than 3000 are approved by financial controller

Re: IF Function

Anil_Babu_Samineni — Mon, 15 May 2017 02:07:55 GMT

Good, If you got answer please close this thread