Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Choose particular item in table

HI,

i have a simple table where a 'Fruits Name' column contains

Fruits Name

----------------

Orange

Banana

Grapes

Apple

here i need it to show all fruits except Banana and Grapes.

How could i do this.

Tags (1)
5 Replies
sureshqv
Esteemed Contributor III

Re: Choose particular item in table

try this

fr:

LOAD * INLINE [

    fruits,

    Orange

    Banana

    Grapes

    Apple

   

];

new:

LOAD Fruits

Where not Exists ='Banana'and 'Apple';

MVP
MVP

Re: Choose particular item in table

Are you looking for a front end expression:

=Sum({<fruits -= {'Banana', 'Grapes'}>} Amount)

sureshqv
Esteemed Contributor III

Re: Choose particular item in table

r try this

fr:

LOAD * INLINE [

    fruits,

    Orange

    Banana

    Grapes

    Apple

   

];

new:

LOAD fruits

Where not Match(fruits,'Banana'and 'Apple')  ;

berryandcherry6
Contributor II

Re: Choose particular item in table

Hi,

Thanks for reply

yes, i am using front end code.

i am using below condition,here how could i apply given logic.So that it shows all campaign except those two.

if(GetSelectedCount(select choice)>0,Fruits Name)

Not applicable

Re: Choose particular item in table

Hi supriya,

Try this i hope it will work

For script end you use where not match([Fruits name],'Banana','Grapes');

Else

In front end you can use this below expression

=sum({<fruits =e($(=fruits={'Banana,'Grapes'}))>} Amount)