topic Drill down to a different object in QlikView

Drill down to a different object

Anonymous — Thu, 20 May 2010 13:34:02 GMT

I have a simple line chart (x axis : Mon-yy, y axis : Sum of dollars). What I want is when I double click on a line, it opens up the detailed transactions which makes up the dollars in a table format.

I am thinking of having a chart & a table with conditional display, but not sure how I can pull it off. Any ideas?

Thanks,

Dinesh.

Drill down to a different object

Thu, 20 May 2010 14:11:38 GMT

If my thinking is correct, when you double click on a line then that will probably select a single date, therefore, you could create your table object and give it a conditional show expression (in the layout tab), the expression would be something like:

GetSelectedCount("YourDateFieldName") = 1

That means, the table object will only show when only a single date is selected.

Drill down to a different object

boorgura — Thu, 20 May 2010 15:09:08 GMT

Nigel,

I would agree with you.

But the only concern is - if a user selects a single date - I would assume it displays the TABLE.

not sure if that was fine.

Drill down to a different object

Anonymous — Thu, 20 May 2010 15:24:23 GMT

What I really want is that depending on which line & which month the user clicks, the table displays the appropriate details. Any suggestions?

Thanks