6 Replies Latest reply: Feb 23, 2012 5:15 AM by Sunil Chauhan

trim text in legend using left function

Anne Duffy Feb 22, 2012 10:48 AM

Hi guys,

I have a field that is made up of joining 2 other field to create a unique key that a map for cycle time is calcuated on , See below :

Field 1	Field 2	Unique
Groceries	Bread	GroceriesBread
Groceries	Gloves	GroceriesGloves
Clothing	Shoes	ClothingShoes
Groceries	Milk	GroceriesMilk
Clothing	Gloves	ClothingGloves
Clothing	Hats	ClothingHats

This is the map so even though field 2 has Gloves in it twice we can determine diff cycle times based on field 1.

Unique	Time to complete
GroceriesBread	5
GroceriesGloves	10
ClothingShoes	10
GroceriesMilk	5
ClothingGloves	15
ClothingHats	10

Anyhow, now we have a chart based on Unique field -- But in the legend it is displayed as the unique title we would like to trim field 1 from this in display of chart

Using Excel we would do the following --- Is there an equivalent in Qlikview

=IF(LEFT([Field1],1)="G",TRIM(MID([Field1],10,20)),IF(LEFT([Field1],1)="C",TRIM(MID([Field1],9,20))))

Thanks

trim text in legend using left function

Dennis Hoogenboom Feb 23, 2012 3:13 AM (in response to Anne Duffy)

What result are you looking for?
Like Show 0 Likes (0)

Actions
- trim text in legend using left function
  
  Celambarasan Adhimulam Feb 23, 2012 3:19 AM (in response to Dennis Hoogenboom )
  
  Hi,
  You can use the same thing as below
  =IF(LEFT([Field1],1)="G",Right([Field1],len([Field1])-10),IF(LEFT([Field1],1)="C",Right([Field1],len([Field1])-9))
  
  Hope its your need
  Celambarasan
  
  Like Show 0 Likes (0)
  
  Actions
trim text in legend using left function

jagan mohan rao appala Feb 23, 2012 3:37 AM (in response to Anne Duffy)

Hi,

The below expression will directly Trim Field1 in Unqiue Field

=Replace(Unique, Field1, '')

Instead why can't you directly use Field2 as dimension.

Regards,
Jagan.
Like Show 0 Likes (0)

Actions
- trim text in legend using left function
  
  Anne Duffy Feb 23, 2012 4:18 AM (in response to jagan mohan rao appala )
  
  Hi Guys
  
  I wish to get the result :
  
  Bread
  Gloves
  Shoes
  Milk
  Gloves
  Hat
  
  Jagan do I use the above as a calculate Expression ?
  
  Thanks
  
  Like Show 0 Likes (0)
  
  Actions
  - trim text in legend using left function
    
    jagan mohan rao appala Feb 23, 2012 4:51 AM (in response to Anne Duffy)
    
    hi,
    
    Try using this Calculated Dimension, I think it works.
    
    Regards,
    Jagan.
    
    Like Show 0 Likes (0)
    
    Actions
    - trim text in legend using left function
      
      Sunil Chauhan Feb 23, 2012 5:15 AM (in response to jagan mohan rao appala )
      
      spece should be like below
      =replace(Unique,[Field 1],' ')
      
      use in dimension
      
      hope this helps
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post