topic Re: Expanding row based on date selection in QlikView

Expanding row based on date selection

Mon, 27 Apr 2015 09:28:40 GMT

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

Re: Expanding row based on date selection

awhitfield — Mon, 27 Apr 2015 09:35:18 GMT

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

Re: Expanding row based on date selection

fvelascog72 — Mon, 27 Apr 2015 09:52:10 GMT

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

Re: Expanding row based on date selection

Tue, 28 Apr 2015 05:50:18 GMT

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

Re: Expanding row based on date selection

Tue, 28 Apr 2015 05:50:51 GMT

Re: Expanding row based on date selection

vikramv — Tue, 28 Apr 2015 05:59:02 GMT

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.

Re: Expanding row based on date selection

Tue, 28 Apr 2015 06:31:03 GMT

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

Re: Expanding row based on date selection

Wed, 29 Apr 2015 04:26:22 GMT

Hi i found my solution here

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