Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Clarification in the List box

Hello Friends,

As I have four inline attributes like in the below, I would like to create a list box that should not show Mar in the list box and rest should show.

How to block the month Mar.

Load * Inline[

Month

Jan

Feb

Mar

Apr] ;

Regards

Chriss

Labels (1)
1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

In Listbox expression use if(not wildmatch(Month,'*Mar*'),Month)

View solution in original post

5 Replies
sivarajs
Specialist II
Specialist II

In Listbox expression use if(not wildmatch(Month,'*Mar*'),Month)

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Try this code.

T_Month:

Load 

IF (Month= 'Mar',Null(),Month) AS Month

Resident TableName;

Regards,

Nirav Bhimani

Not applicable
Author

Hello Sivaraj and Nirav,

Owesome, it works...

Regrads

Chirss

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi Sivaraj & Chriss,

Can you please share a demo file of the expression which is working in above case.

In my case ur expression is not working.

Regards,

Nirav Bhimani

sivarajs
Specialist II
Specialist II

Hey Check the attachment