topic Re: Dimension in QlikView

Dimension

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

In the bar chart Under dimension from Product Field i want to displace only two products Resistivity and sensitivty

Please let me know if iam using correct formula ?

=if(Match(Product,'Gillet' ,'oldSpice'),Product)

for the above expression iam geting only Gillet but not oldspice.

Re: Dimension

kaushiknsolanki — Thu, 10 Mar 2016 06:17:33 GMT

Try wildmatch function instead of match.

Also include * before and after value

Regards,

Kaushik solanki

Re: Dimension

Chanty4u — Thu, 10 Mar 2016 06:17:41 GMT

=if(WildMatch(Product, '*Gillet*', '*oldSpice*'), 'product') as NewField

Re: Dimension

smilingjohn — Thu, 10 Mar 2016 06:20:29 GMT

Iam trying this under dimension of bar chart .

So i think i cannot use AS

Re: Dimension

its_anandrjs — Thu, 10 Mar 2016 06:21:00 GMT

Hi,

Your expression is correct

=if(Match(Product,'Gillet' ,'oldSpice'),Product)

You can try this also

=if(Product = 'Gillet' , 'Gillet',

if(Product = 'oldSpice' , 'oldSpice'))

And use suppress when value is null

Regards

Anand

Re: Dimension

Chanty4u — Thu, 10 Mar 2016 06:21:44 GMT

yes u can create a flag in back end and u can get directly..

Re: Dimension

smilingjohn — Thu, 10 Mar 2016 06:22:11 GMT

Hi Kaushik,

Iam trying to use this in a bar chart under Dimensions "Add Calculated Dimension" ?so how do i use

Re: Dimension

smilingjohn — Thu, 10 Mar 2016 06:25:36 GMT

Hi Anand thanks for your reply

I tried your expression too but yet its diplaying only Gillete , its not displaying both

Actually ther are 7 productins in that field out of which i want to display only 2 products in the bar graph

Re: Dimension

Kushal_Chawda — Thu, 10 Mar 2016 06:26:19 GMT

try this

if(Match(lower(trim(Product)),'gillet' ,'oldspice'),Product)

Re: Dimension

kaushiknsolanki — Thu, 10 Mar 2016 06:28:35 GMT

Try this way,

=if(wildMatch(Product,'*Gillet*' ,'*oldSpice*),Product)

Regards,

Kaushik solanki

Re: Dimension

its_anandrjs — Thu, 10 Mar 2016 06:28:58 GMT

Try to check the spellings of the Gillet and oldSpice in the field Product or may be you can use if condition as calculated dimension that i suggest or you can use WildMatch also here.

can you provide the list of Product field items for look out.

Regards

Anand

Re: Dimension

kaushiknsolanki — Thu, 10 Mar 2016 06:29:31 GMT

Sorry missed one quote

=if(wildMatch(Product,'*Gillet*' ,'*oldSpice*'),Product)

Re: Dimension

Chanty4u — Thu, 10 Mar 2016 06:32:54 GMT

u just remove as newfield

Re: Dimension

avinashelite — Thu, 10 Mar 2016 07:03:23 GMT

Try like this

=if(Match(upper(Product),'GILLET' ,'OLDSPICE'),Product)

this should work

Re: Dimension

Chanty4u — Thu, 10 Mar 2016 07:07:36 GMT

try this too

=if ( wildMatch(upper(Product), '*GILLET*') and wildmatch(upper(Product), '*OLDSPICE*' ),'Product')

Re: Dimension

sasikanth — Thu, 10 Mar 2016 07:10:59 GMT

hi,

If the values are fixed you can try this way

Calculated Dimension:

pick (WildMatch( upper(Product), '*GILLET*', '*OLDSPICE*'),'Gillet', 'oldSpice')

Check the option suppress NULL values