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

[Anonymous]

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

[pgalvezt]

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!

[#3]

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

[Anonymous]

Hi

     Give me some clear example for your requirement or any sample qv file related to your requirement

Regards

[#5]

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

[#6]

Hello Shubham Kumar,

try to build a dynamic dimension like this:

if ( Status= 'OPEN' or Status= 'PENDING', Status)

Regards, Roland

[Anonymous]

Hi

hope the following attached file will be helpful for your requirement

Regards

Ashok

[flipside]

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