Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you provide some sample data?
Type Number
Establish 23
Testing 4
Duplication 45
Duplication 55
i want to shpw only duplication -number
Regards,
Prajna
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;
I want to achieve in expression.
I want to display number for type ='Duplication'
Regards,
Prajna
Create a text box and type below...
=CONCAT(IF(Type = 'Duplication',Number),', ')
its giving me wrong data.
I have a table which holds type and number.
Regards,
prajna
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.
I want to show in bar chart . I have other dimesnions as well like clender values .Amount
Regards,
Prajna
Can you provide us more sample data. It would be good idea rather than just guessing what you want.
Thanks..