topic Re: If and AND statement in QlikView

If and AND statement

Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

STREET NUMBER COMPANY

Lowland 5 Datatec

Lowland 7 Datatec

Lowland 10 StrategicAnalysis

Buitenland 24 Conecxion

Spoorweg 16 InfoTec

Spooweg 20 Datatec

Heuvel 3 Lifestyle

Milieu 14 BrainTec

Lowland 8 BrainTec

Milieu 9 Datatec

Heuvel 6 Datatec

Highland 15 Healthcaresolutions

Lowland 11 Healthcaresolutions

From the table above I want to be able to say : IF COMPANY = Datatec AND STREET = Lowland AND NUMBER = 5, then a message should be displayed "The best HighTec Company" . Please any help on how to write these expression?

Re: If and AND statement

MindaugasBacius — Mon, 30 May 2016 08:49:41 GMT

If(COMPANY = 'Datatec' and STREET = 'Lowland' and NUMBER = 5, 'The best HighTec Company', 'Other') as Score

This works for your needs.

Re: If and AND statement

avinashelite — Mon, 30 May 2016 08:49:54 GMT

try like this

if(COMPANY = Datatec AND STREET = Lowland AND NUMBER = 5,'The best HighTec Company')

Re: If and AND statement

swuehl — Mon, 30 May 2016 08:50:43 GMT

For example, create a text box with expression:

=IF( COMPANY = 'Datatec' AND STREET = 'Lowland' AND NUMBER = 5,'The best HighTec Company')

and also create a show condititon on layout tab:

=COMPANY = 'Datatec' AND STREET = 'Lowland' AND NUMBER = 5

This will show the message if you have limited the data set to only these values.

Re: If and AND statement

Mon, 30 May 2016 09:42:48 GMT

Hey Avinash,

Thanks alot it worked.

Best,Simon