topic Re: Conditionnal dimension (text not like) in QlikView

Conditionnal dimension (text not like)

Mon, 10 Mar 2014 11:14:41 GMT

Hi everyone, I've got a problem. It must be easy, but I still haven't figured it out how to solve it.

If in my chart, I put a condion on one of my dimension like "=fonc_nom_budget like '*Principal*'", I have the result that I want.

If I want to have the opposite result, like "=not(fonc_nom_budget like '*Principal*')" , it doesn't.

It doesn't pick out the name with "Principal" in. I've got all the possible results.

I've tried with =fonc_nom_budget<>'Principal' , same thing. I'm sure that it's easy, but I can't find it.

Thanks for the help !

MK_QSL — Mon, 10 Mar 2014 11:23:22 GMT

=IF(fonc_nom_budget<>'Principal' , fonc_nom_budget)

alexandros17 — Mon, 10 Mar 2014 11:25:18 GMT

Do not use like, use wildmatch(fonc_nom_budget , 'Principal')'

In this way you can test

wildmatch(fonc_nom_budget , 'Principal')' = -1 (True)

wildmatch(fonc_nom_budget , 'Principal')' = 0 (False)

Hope it helps

er_mohit — Mon, 10 Mar 2014 11:25:30 GMT

USE WILDMATCH FUNCTION like

if(wildmatch(fonc_nom_budget ,'*Principal*'),fonc_nom_budget )

for not match try this

if(fonc_nom_budget <>wildmatch(fonc_nom_budget ,'*Principal*'),fonc_nom_budget )

Mon, 10 Mar 2014 13:11:42 GMT

Thanks all, I used a mix of your answers : =if(wildmatch(fonc_nom_budget ,'*PRINCIPAL*')=0,fonc_nom_budget )