topic Re: Exlcude one dimension in QlikView

Exlcude one dimension

Thu, 24 Oct 2013 12:01:07 GMT

I need a bar chart showing the top 5 defects excluding any with the word 'Delay' in them. I have not been able to get the format right for Defect not like '*Delay*' in my expression defintion.

Re: Exlcude one dimension

tresB — Thu, 24 Oct 2013 12:03:19 GMT

Try wildmatch()

Re: Exlcude one dimension

salto — Thu, 24 Oct 2013 12:04:21 GMT

Hello,

the expression should exclude the value more or less like this:

count({$<DefectDescription={"*"}-{"*Delay*}>}[DefectID])

Hope this helps...

Re: Exlcude one dimension

jchoucq — Thu, 24 Oct 2013 12:07:17 GMT

hi,

i will try

count({$<DefectDescription-={"*Delay*"}>}[DefectID])

Regards,

Johann

Re: Exlcude one dimension

Thu, 24 Oct 2013 12:07:20 GMT

Hi Rob,

Check if the below expression works

wildmatch(text,'*Delay*')

Regards,

Varsha