Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vipin_mishra479
Contributor II

Exclude data problem

hiiii, i am upload the qvw file in this file there have a two field vertical and plant

in this qvw i want exclude two plant 2060 and 2080 from Nacelle

1 Solution

Accepted Solutions

Re: Exclude data problem

LOAD * INLINE [

    Vertical, Plant

    Nacelle, 1009

    Nacelle, 1004

    Nacelle, 1005

    Nacelle, 2060

    Nacelle, 2080

    Blade, 2009

    Blade, 1289

    Blade, 1233

    Electrical, 1500

    Electrical, 1555

    Electrical, 2606

    Electrical, 2608

]

WHERE if(Vertical = 'Nacelle', Plant <> 2060 AND Plant <> 2080, Plant);

3 Replies

Re: Exclude data problem

LOAD * INLINE [

    Vertical, Plant

    Nacelle, 1009

    Nacelle, 1004

    Nacelle, 1005

    Nacelle, 2060

    Nacelle, 2080

    Blade, 2009

    Blade, 1289

    Blade, 1233

    Electrical, 1500

    Electrical, 1555

    Electrical, 2606

    Electrical, 2608

]

WHERE Plant <> 2060 AND Plant <> 2080;

vipin_mishra479
Contributor II

Re: Exclude data problem

but in Electrical i want to show that plant i want to exclude only vertical = Nacelle

Re: Exclude data problem

LOAD * INLINE [

    Vertical, Plant

    Nacelle, 1009

    Nacelle, 1004

    Nacelle, 1005

    Nacelle, 2060

    Nacelle, 2080

    Blade, 2009

    Blade, 1289

    Blade, 1233

    Electrical, 1500

    Electrical, 1555

    Electrical, 2606

    Electrical, 2608

]

WHERE if(Vertical = 'Nacelle', Plant <> 2060 AND Plant <> 2080, Plant);

Community Browser