topic Display in Straight table based on condition data in QlikView

Display in Straight table based on condition data

jagannalla — Sat, 25 Jun 2011 09:04:03 GMT

Hi,

I have a table with two fields like this:

Table1:

ID, Status

1, pass

2, fail

3, pass

1, fail

2,pass

3,pass

- Now i will take straight table with ID.

- In the expression i want to write like this if the status is fail for any particular ID i want to display as fail under status.

i.e in the above data for id=1 there are 2 status(2 fails,1 pass) so i need to get fail under status.

For example i want to display in straight table like this:

     ID     Status
     1       Fail
     2       Fail
     3       pass

how can i do this

kaushiknsolanki — Sat, 25 Jun 2011 10:08:55 GMT

Hi,

Create a Straight table.

Add dimension as ID

and Expression as

if(count({<Status = {"fail"}>}ID)>=count({<Status = {"pass"}>}ID),'Fail','Pass')

Regards,

Kaushik Solanki

jagannalla — Sat, 25 Jun 2011 10:47:57 GMT

Thanks kaushik..