Expanding row based on date selection

[#1]

Hi  I have a pivot table where i am showing number of time a country name occurred in a column(basically i am taking number of click on selected date range).I am using calendar object to select the date range.I have a text object "show More Info" on the bottom of table,on clicking this i want to show another table with more information ,like when  i am clicking the row USA then i want to show number of times  USA occurred  on January,February,march and April if my selected date range is 01-01-2015 to 26-04-2015  and  also i want to hide the detailed table on clicking"Hide Info" text object.Below attached are design i am trying to implement(designed in excel ).Since i am new to qlikview i am not sure whether this  is possible

[awhitfield]

Hi Ryan,

you would do this using conditional hide/shoe, have a look at the simple example attached. Basic you create a  variable, the buttons set the value of the variable, and the chart either hide or show dependant upon the value of the variable.

Andy

[fvelascog72]

Hi, Why dont you use a pivot table and show the information with expand all/colapse all?

[#4]

Thank you for the help actually i want to show the date fields below the selected country row.When i am adding date as dimension and expanding the row the corresponding values are shown in different column

[#5]

Thank you for the help actually i want to show the date fields below the selected country row.When i am adding date as dimension and expanding the row the corresponding values are shown in different column

[vikramv]

Hi,

Use two tables and under the Layout --> Conditional , Give the conditions "Such as Get Field Selections" for each of the tables based on selections.

Thanks,

Vikram.

[#7]

Hi Thank you fro your help,but i am new to qlikview will you please elaborate.

[#8]

Hi i found my solution here

Using Column Visibility | Qlikview Cookbook, Thank you for all you helps