Dynamically view a table by clicking on a column header of another table.

[#1]

Hi All,

I had a query regarding Straight tables.

I have created a straight table using Qlikview. What i want to show is that when i click on one of the column header of the table, the click should help me display another table. I thought of using variables for this. But i am not really sure if i can assign a variable on the column header.

Is it possible to create a variable in column header in a straight table so as to display another table as a pop up through that column header?

Please provide a solution if it is possible or do let me know if there is a turnaround of that situation.

Thanks in advance!

[Anonymous]

Shakala

This is a bit off a bit a kludge, but how about

• Creating a Text Object with nothing in it and making it transparent
• Add a Action to do what you wish, as in maybe set a variable
• Place this Text Object over the column header

Best Regards,     Bill

[suresh_rawat]

Hi Shalaka,

Yes you can did this in Straight table by following such steps:

- Create a variable -> for eg : vShow

- Create a Textbox -> Properties -> General - name shoud be same as the name of the column.

- Properties - > In Action - > set variable - > variable name - vShow -> value - =if(vvShow = 0,1,0)

- Place the text object over the column name in a chart by transparent it make his layout greater then the chart layout.

- Then give condition to the object you want to show after clicking on the column - > Properties - > Layout - > Condition -> vShow = 1.

I hope this will help you, if you still have some doubt you can raise your point here.

Regards

Suresh Rawat