
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
SUM when column contain a certain word
Hi,
I have the following expression:
SUM
(if(DIENSTJAAR <= DIENSTJAAR_TM, if(DIENSTJAAR >= DIENSTJAAR_VANAF, BEDRAG_BEGROOT)))DIENSTJAAR stands for a year
BEDRAG_BEGROOT stands for a certain amount of money
Now hat i want to do is SUM BEDRAG_BEGROOT, but only where an other text column (named OMSCHRIJVING) contains the word 'inhuur'.
Does somebody know what to do?
- Tags:
- new_to_qlikview
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
at first pay attention to the ELSE expression that you have not specified in IF;
For The condition you want to add :
1) you can use set analysys
2) you can add the condition if(substringcount ( OMSCHRIJVING, 'inhuur')>0) that returns number of times the word 'inhuur' appear in OMSCHRIJVING
Hope it helps


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
at first pay attention to the ELSE expression that you have not specified in IF;
For The condition you want to add :
1) you can use set analysys
2) you can add the condition if(substringcount ( OMSCHRIJVING, 'inhuur')>0) that returns number of times the word 'inhuur' appear in OMSCHRIJVING
Hope it helps

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Its working now, thanks!
