topic Re: How to write multiple where conditions in single table? in QlikView

How to write multiple where conditions in single table?

daisy1438 — Wed, 25 Nov 2020 16:16:04 GMT

I have two requirements below.

1)in my table one of the field data like below

DATA: require output:

Uk Uk
US Us

- India

India

-missing-

123

134

when loading time remove '-' and '123' and '-Missing'.

same time i need to write where date>='01/01/208'.

already i am using where <>missing condtion it working.but its remove only -missing-.i need to remove -,123,-missing.and where time>='01/01/2018'

Anil_Babu_Samineni — Sun, 11 Feb 2018 04:03:23 GMT

May be use And Operator to work more than one condition like?

Load * From Table Where Not Match(Date, '-missing-', '-', '123') and time >= '01/01/2018';

shiveshsingh — Sun, 11 Feb 2018 13:47:24 GMT

You can use where not match('Field Name','Value1','Value2')