Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expanding row based on date selection

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

tabl1.jpgtab2.png

7 Replies
awhitfield
Partner - Champion
Partner - Champion

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
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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

Not applicable
Author

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
Creator III
Creator III

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.

Not applicable
Author

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

Not applicable
Author

Hi i found my solution here

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