Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Filtering for Multiple Items in the Load statment

Hello I am trying to filter for multiple items  in my load statement.

I've tried Where Exists & Where IN and it doesn't accept either...

LOAD

    "Date of AR Run",

    "Practice Name",

    "Insurance Name",

    "IB 30",

    "IB 31 to 60",

    "IB 61 to 90",

    "IB 91 to 120",

    "IB Over 121",

    "Total IB",

    PAYER_GROUP

FROM [lib://DATAMART BACKUP/INSAGINGDETAIL_2017.csv]

(txt, utf8, embedded labels, delimiter is ',', msq)

WHERE Exists("Practice Name", 'Derm 1', 'Derm 2', 'Derm 3')

Thanks in advance.

Tags (1)
4 Replies
YoussefBelloum
Esteemed Contributor

Re: Filtering for Multiple Items in the Load statment

Hi,

LOAD

    "Date of AR Run",

    "Practice Name",

    "Insurance Name",

    "IB 30",

    "IB 31 to 60",

    "IB 61 to 90",

    "IB 91 to 120",

    "IB Over 121",

    "Total IB",

    PAYER_GROUP

FROM [lib://DATAMART BACKUP/INSAGINGDETAIL_2017.csv]

(txt, utf8, embedded labels, delimiter is ',', msq)

WHERE Match("Practice Name", 'Derm 1', 'Derm 2', 'Derm 3')

YoussefBelloum
Esteemed Contributor

Re: Filtering for Multiple Items in the Load statment

did it works for you ?

akuttler
Contributor

Re: Filtering for Multiple Items in the Load statment

Yes it works. THanks!

YoussefBelloum
Esteemed Contributor

Re: Filtering for Multiple Items in the Load statment

you're welcome

you can close the thread by marking correct answer as correct

Community Browser