Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
fr:
LOAD * INLINE [
fruits,
Orange
Banana
Grapes
Apple
];
new:
LOAD Fruits
Where not Exists ='Banana'and 'Apple';
Are you looking for a front end expression:
=Sum({<fruits -= {'Banana', 'Grapes'}>} Amount)
r try this
fr:
LOAD * INLINE [
fruits,
Orange
Banana
Grapes
Apple
];
new:
LOAD fruits
Where not Match(fruits,'Banana'and 'Apple') ;
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)
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)