Showing Records in in Qlikview Drill down

[deepakqlikview_123]

Hi all,

I have overlapping of 2 charts.

In main chart I have 4 column A ,B,C,D

Out of that A is dimension and B, C,D are expressions having count of Records.

Suppose B,C,D has count of records 3,4,5 resply when I can click on B it should show 3 records in drill down chart when I can click on C 4 records in drill down chart and for D 5 records should be displayed in drill down chart.

Can you please suggest how to proceed.

Thanks

[hector_munoz]

Hi Deepak,

• In script you could create a new table with dimensions B, C and D and associate each detailed record with the proper B, C or D values.

• In design you could replace 3 expresions by one and adding a new dimension with the field of B, C and D values...

Could be possible?

regards,
H

[avinashelite]

I don't think we have a direct method to achieve this ..you could try with the macro action trigger in the chart ...

OR

on the First chart on the labels you could place the text box and trigger the action but remember you should have limited row and you cannot have multiple rows ...if you have multiple rows then you could try with Document chaining with the parameter passing and link option

hope this helps you 

[deepakqlikview_123]

Can you please share example how it can be implemented using macro

Thanks