Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi, Why dont you use a pivot table and show the information with expand all/colapse all?
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
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
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.
Hi Thank you fro your help,but i am new to qlikview will you please elaborate.
Hi i found my solution here
Using Column Visibility | Qlikview Cookbook, Thank you for all you helps