topic Re: Calculated Dimension in QlikView

Calculated Dimension

NickBentley — Sat, 24 Jul 2021 03:31:39 GMT

I am trying to make a calculated dimension from my 'Customer' dimension which only displays the customers that have the contain the word 'value' in their title.

I have tried the expression below, but this in just giving me a 1 / 0 result (which I am assuming is yes / no) but would like the list of the 25 or so customers that I know have 'value in their name.

=Wildmatch(Customer,'value*')

Thanks.

Re: Calculated Dimension

Vikash — Sun, 25 Jul 2021 10:54:30 GMT

Hi Nick,

Please try the below expression as your calculated dimension-

=If(Wildmatch(Customer,'value*'), Customer)

Regards,

Re: Calculated Dimension

NickBentley — Mon, 26 Jul 2021 23:30:39 GMT

Thanks for the reply VK.

Worked a treat!

Cheers,

Nick