topic Straight Table and Click behavior in QlikView

Straight Table and Click behavior

Thu, 17 Jul 2014 21:44:26 GMT

Hi All,

I have a question.

I made a table which has "status" as dimension and "Date" as expression and set Horizontal. But when I click a cell, it choose only "Date". I want to choose both "Status" and "Date".

I have to make a table in the layout and I don't use any filter. I want to do just one click and show up the drill down result in another object.

Please see attachment.

How can I make such a table keeping the layout? Do you have any idea?

Regards,

Yoshi

Re: Straight Table and Click behavior

Fri, 18 Jul 2014 04:41:17 GMT

Hi Yoshi

I tried it with a pivot table using only date and status as dimension and number as expression. When you click on a number it will select the date and the status...

See the qvw attached:

Let me know if this is what you were looking for.

regards,

Anthony

Re: Straight Table and Click behavior

Fri, 18 Jul 2014 12:04:55 GMT

Hi Anthony,

Thank you for your reply. Yes, that is what I wanted. I didn't know that I can drag & drop a dimension to another field on Pivot table too.

Thank you very much!

Yoshi