where clause in expression

[#1]

Hi,

I want to get field value based on filter criteria.

ex: field1value='A',get me field2

Earlier i used set analysis to get count

count({$<Type={'DUPLICATION'}>}ID) 

Now i want just value of other field.if its of type duplication

Regards,

Prajna

[MK_QSL]

Can you provide some sample data?

[#3]

Type                        Number

Establish                     23

Testing                         4

Duplication                    45

Duplication                    55

i want to shpw only duplication -number

Regards,

Prajna

[MK_QSL]

Temp:

Load * Inline

[

Type,                        Number

Establish,                     23

Testing,                       4

Duplication,                    45

Duplication,                    55

];

Join

Load Type, COUNT(Number) as Flag Resident Temp Group By Type;

NoConcatenate

Final:

Load * Resident Temp where Flag >1;

Drop Table Temp;

[#5]

I want to achieve in expression.

I want to display number for type ='Duplication'

Regards,

Prajna

[MK_QSL]

Create a text box and type below...

=CONCAT(IF(Type = 'Duplication',Number),', ')

[#7]

its giving me wrong data.

I have a table which holds type and number.

Regards,

prajna

[Anonymous]

do you want to show Number field of Duplication type??

if yes,then you can refer the attached QVW for work around.

Hope it helps.

[#9]

I want to show in bar chart . I have other dimesnions as well like clender values .Amount

Regards,

Prajna

[MK_QSL]

Can you provide us more sample data. It would be good idea rather than just guessing what you want.

Thanks..