how to show results in a straight table conditionally??

[sushil353]

Hi All,

In my dashboard i have a straight table in which simple calculation is done. There are fields in dashboard Like "Failures"......

I want to show data in that straight table when user selects value from Failures.. otherwise it should show ' 0'.

Please find the attached application...  and help me out to solve this requirement..

Thanks

Sushil

[richard_chilvers]

Hi Sushil

Can you explain your requirement a little more ?

You have table called Failure which lists items (which may fail, I guess).

You have another table which counts the Failures. If I select a Failed item, I seem to get the correct count - do you not agree ? Can you suggest an item which has had no failures, but which shows a value for the count ?

You may also want to review your table links - QlikView has automatically created synthetic keys, but it is usually advised that your data is managed in a way to avoid this. There is some useful information in the documentation on this.

Hope this helps.

[jagan · Accepted solution]

Hi Sushil,

Use this expression

Failure Count = =If(GetSelectedCount(bsn_details_fdat.TT_TYPE) > 0, Count(bsn_details_fdat.TT_TYPE) , 0)

Hope this helps you.

Regards,

Jagan.