topic Re: Dynamic Chart selection with drill down capability in QlikView

Dynamic Chart selection with drill down capability

cliff_clayman — Thu, 04 Aug 2016 15:28:02 GMT

I currently have a chart that shows number of transaction per month for a year. You can click into a month to see the number of transactions for that particular month only. What I would like to do is add a further drill down option to see each date for a chosen month's transactions. I'd like a button that is only visible when a month is currently chosen that when selected it displays the transactions by date. How can I dynamically display the button and the chart with dates?

Re: Dynamic Chart selection with drill down capability

Anonymous — Thu, 04 Aug 2016 15:56:27 GMT

On the Layout tab of the button, you can put GetSelectedCount(Month) = 1 in the Conditional window so it will only appear if you have 1 month selected.

Re: Dynamic Chart selection with drill down capability

cliff_clayman — Thu, 04 Aug 2016 16:00:37 GMT

What is the best way to create the button?

Re: Dynamic Chart selection with drill down capability

vishsaggi — Thu, 04 Aug 2016 16:09:35 GMT

Why dont you use drill down functionality (Group) in Qlikview, will that suffice your requirement.

Create a Drill down group with Year, Month,Date. Provided you have date fields with valid dates.

What is the button used for, here?

Thanks,
V.

Re: Dynamic Chart selection with drill down capability

cliff_clayman — Thu, 04 Aug 2016 16:11:30 GMT

How do I create a Group? I do have a date field with valid dates.

Re: Dynamic Chart selection with drill down capability

vamsee — Thu, 04 Aug 2016 16:15:01 GMT

Either conditionally display the Date column

condition

GetSelectedcount(Month)=1

or as vishsaggi‌ said use drill down.

I would suggest drill down.

As your question goes for the button create a Variable and a button to trigger that variable.

Conditionally display your date column if the value of the variable is 1.

Thanks

Re: Dynamic Chart selection with drill down capability

NickHoff — Thu, 04 Aug 2016 16:17:29 GMT

On your dimension tab you will see the following:

Next you choose new group:

In your group creation the first field will be your Month the Second field will be your Date. Make sure to use the drill down option and not cycle.

Once you create the drill down group add it to your chart object as a dimension

Re: Dynamic Chart selection with drill down capability

vishsaggi — Thu, 04 Aug 2016 16:21:00 GMT

In the chart (Any chart) properties -> Dimensions Tab -> follow this screenshot.

Another way You can also create groups using Doc Properties -> Group Tab.