Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-12-08 06:56 AM

Exclude values to another group

Hello you all,

Got a situation where I want te exclude some values from a field called Gegevens into another field, but can't get the syntax right. My code so far:

Load
IF(Trim(Gegevens)= 'H900: P/dgdl. dagbest. VG-licht (VG1-VG4)', 'H900: P/dgdl. dagbest. VG-licht (VG1-VG4)',
IF(Trim(Gegevens)= 'H901: P/dgdl. dagbest. VG-mid. (VG5,VG6)', 'H901: P/dgdl. dagbest. VG-mid. (VG5,VG6)',
IF(Trim(Gegevens)= 'H902: P/dgdl. dagbest. VG-zwaar (VG7)', 'H902: P/dgdl. dagbest. VG-zwaar (VG7)'))) as Gegevens2,
Gegevens as ZZP

Now I want to get two different fields: Gegevens2 and ZZP. My code does this BUT the 3 values mentioned (H900, H901, H901) are now included in both fields. I want those 3 values into field Gegeven2 and OUT of field ZZP.

Can anyone help me?

Regards,

Sanchez

1,035 Views
0 Likes
10 Replies
Not applicable
‎2010-12-10 06:15 AM
Author

In response to

I'm not that technical so unfortunaltely I can't get it working the proper way.

I've made a work arround by creating an action on opening the tab that pre selects the ZZP values and on another tab pre selects the Gegegevens2 field values. This is a simple way to get it working.

Thx for your help.

72 Views
0 Likes