7 Replies Latest reply: Feb 21, 2012 8:17 AM by Dave Riley

How to show only one value(Text) of any of the fields?

Shubham Kumar Nov 30, 2011 1:18 AM

Hi,

I want to take only one value from the particular some field. If I take the list box and show that field, it shows all the text value which is there. but I want to get only one particular value. I tried Only( Field=' text') but it shows then text-1, for remaining text 0 but still shows all the fields.

Should you have any further clarification, please let me know.

Best,

Shubham Kumar

How to show only one value(Text) of any of the fields?

Pablo GÃ¡lvez Feb 14, 2012 2:07 PM (in response to Shubham Kumar)

I would like to know the same. I have 5 values into the table PIF, POT,TRS,IUY,QDP. I need to show just POT and all the filtres asociated.

Thanks!
Like Show 0 Likes (0)

Actions
- How to show only one value(Text) of any of the fields?
  
  Edward Davies Feb 21, 2012 6:31 AM (in response to Pablo GÃ¡lvez)
  
  I also have a similar requirement - I would like to only display 2 particular values from a column that has many values. Any ideas would be great
  
  Like Show 0 Likes (0)
  
  Actions
- How to show only one value(Text) of any of the fields?
  
  Ashok Chandran Feb 21, 2012 7:07 AM (in response to Pablo GÃ¡lvez)
  
  Hi
  
  Give me some clear example for your requirement or any sample qv file related to your requirement
  
  Regards
  
  Like Show 0 Likes (0)
  
  Actions
  - How to show only one value(Text) of any of the fields?
    
    Edward Davies Feb 21, 2012 7:46 AM (in response to Ashok Chandran)
    
    Hi Chandashok,
    
    my example is: I have a straight table with mutliple rows and columns. One of the columns is called "Status" and it has 3 potential values: CLOSED, OPEN or PENDING. However, I only want to load data where status is equal to OPEN or PENDING into this particular table.
    
    thanks
    
    Like Show 0 Likes (0)
    
    Actions
    - How to show only one value(Text) of any of the fields?
      
      Roland Kunle Feb 21, 2012 8:02 AM (in response to Edward Davies)
      
      Hello Shubham Kumar,
      
      try to build a dynamic dimension like this:
      if ( Status= 'OPEN' or Status= 'PENDING', Status)
      
      Regards, Roland
      
      Like Show 0 Likes (0)
      
      Actions
    - Re: How to show only one value(Text) of any of the fields?
      
      Ashok Chandran Feb 21, 2012 8:08 AM (in response to Edward Davies)
      
      Hi
      
      hope the following attached file will be helpful for your requirement
      
      Regards
      
      Ashok
      
      Example.qvw 124.8 K
      
      Like Show 0 Likes (0)
      
      Actions
    - How to show only one value(Text) of any of the fields?
      
      Dave Riley Feb 21, 2012 8:17 AM (in response to Edward Davies)
      
      Hi,
      
      You can also do this easily in the load script such as this example ...
      
      SourceData:
      LOAD * INLINE [
          Reference, Value, Status
          AAA, 100, CLOSED
          BBB, 200, PENDING
          CCC, 100, PENDING
          DDD, 150, CLOSED
          EEE, 653, OPEN
          FFF, 321, OPEN
          GGG, 332, OPEN
          HHH, 325, PENDING
      ];
      LEFT JOIN
      LOAD
      Reference,
      If(Status='CLOSED',Null(),Status) as Status_Filter1
      resident SourceData;
      
      ... then include the new column Status_Filter1 as a dimension and check the "Suppress when value is Null" checkbox.
      
      flipside
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post