Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

Not include in set expression

Hello everyone,

This is my example

COUNT(if(wildmatch(UPPER(field_name),'*value1*','*value2*') AND NOT wildmatch(UPPER(field_name),'*value3*'),field_name3))

with and not wild match I try exclude value3 (I couldnt succeed)

and my second expression is

COUNT({$<field_name2={">=$(=0) <$(=31)"},field_name={'*value1*','*value2*'}>}field_name3

As result I want to combine two expression in one expression

8 Replies
kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Find the attached file

QSense
Creator II
Creator II
Author

hi,

Could you send script file ?

I dont have personal edition

QSense
Creator II
Creator II
Author

hi,

Could you send script file ?

I dont have personal edition

QSense
Creator II
Creator II
Author

hi,

Could you send script file ?

I dont have personal edition

QSense
Creator II
Creator II
Author

hi,

Could you send script file ?

I dont have personal edition

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Script:

temp2:

load * inline [

field_name3, Value,field_name2

1, value1    ,5

2, Svalue2    ,40

3, Svalue2    ,29

4, Svalue3    ,35

] ;

1st:

COUNT(if(wildmatch(Upper(Value),'*value1*','*value2*'),field_name3))

2nd:

COUNT({$<field_name2={">=0 <=31"},Value={"*value1*","*value2*"}>}field_name3)

QSense
Creator II
Creator II
Author

hi,

Could you send script file ?

I dont have personal edition

QSense
Creator II
Creator II
Author

Thanks for reply ,

How can I make in expression not in script side?