topic Re: Drilldown even in QlikView

Drilldown even

Anonymous — Fri, 17 Apr 2015 21:40:16 GMT

Hi All,

My user is comfortable with Drilldown Group ( he don't want cyclic group).

So, I would need to overcome the below functionality :

( "The drill-down function automatically goes down to the next level when there is only one value on the current level. So what happens is most likely that you for some data only have one value in your Priority field.")

i.e., I need to come up with a work around to display the values based on the current level (and not automatically go down to next level when there is only one value

Please advice.

Re: Drilldown even

srchilukoori — Fri, 17 Apr 2015 22:15:11 GMT

You need to build a work around using the getpossiblecount() function.

Re: Drilldown even

srchilukoori — Fri, 17 Apr 2015 22:16:45 GMT

Try the logic from the attached app.

Re: Drilldown even

marcus_sommer — Fri, 17 Apr 2015 22:20:07 GMT

I believe there isn't much to customized on the drilldown group and you will need to build an own logic. Maybe with a variable as dimension which will be controlled by button(s) or an inputbox and/or which changed by an OnSelectionChange trigger and/or by user-selections (which queries the getfieldselctions and makes a counting on these selections) and/or you queries your required group-hierachy with a pick(match()) lookup:

dimension: $(varDimension)

varDimension: if(count(Dimension1) < 2, Dimension2, Dimension1) // query the results from user-selections

I think it will be not quite easy to build such a logic and I assume you will have to combine several from the above mentioned possibilities. Nevertheless I hope it's useful for you.

- Marcus

Re: Drilldown even

petter — Fri, 17 Apr 2015 23:16:00 GMT

It seems that it is possible to trick it into the functionality you want by introducing dummy rows in the data.

This can also be handled by a separate table linked to your main table to make it more clean and efficient.

Here is the quick and dirty solution:

DrillDownGroup:

LOAD * INLINE [

L1, L2, L3, L4,V

A, A2, A3, A4,2

A, A2,

A, A3, A5, A6,3

A, A3,

A, A4, A7, A8,5

B, B2, B3, B4,6

B, B3, B3, B5,7

C, C2,C3,C4,8

C, C2,

];

Row numbers 5,7,12 and 13 are dummy rows to make the drill-down see that it has more values than one but in the front-end you can select "suppress when value is null" under "Settings for Selected Dimension" on the Dimensions tab in the properties of the Straight Table.

Re: Drilldown even

Anonymous — Mon, 04 May 2015 12:34:50 GMT

Hi srchilukoori,

On selection in your Dim1 listbox, it drilldowns to Dim2 in your bar chart.

However, I would like the Dim1 selection to display only the selected value (eg CA, US ) in the bar chart.

ie., if I select US in Dim1 , I would like to see US in Chart. Same for CA.

Re: Drilldown even

Anonymous — Mon, 04 May 2015 12:59:53 GMT

Hi Petter,

in your example, if I create a listbox for L1, and, when I make a selection on only one value in L1, it is creating a drilldown from L1 level to L2 level in the chart. However, I would not like the chart to jump to the next level automatically just because I selected only one value in listbox

Re: Drilldown even

Anonymous — Tue, 05 May 2015 14:15:41 GMT

Hi Gurus,

This issue is still pending.

When selecting one or more values in a list box, the line chart , which has only one line at the highest group level, is automatically jumping to next drilldown level. Please help me to overcome this

Re: Drilldown even

Anonymous — Thu, 14 May 2015 16:15:41 GMT

Hi All,

this solutions is still not working

Please help

Re: Drilldown even

petter — Thu, 14 May 2015 16:23:53 GMT

Give me some motivation then - even though I solved your original problem - you didn't give me a "like" / "helpful" or "answered". I don't want to spend a lot of time helping out unless there is some chance of getting positive feedback...

Re: Drilldown even

Anonymous — Thu, 14 May 2015 17:16:33 GMT

Hi Petter,

Glad to get your attention. However, I feel that the original problem is still not answered.

I'll try to be more clear on the issue I am facing:

When I make selection of more than one value in a listbox, it does not drilldown to next level.

But, when I make selection of only one value in a listbox, it drilldowns to next level.

I do not want the drilldown to go to next level automatically even if only one value is selected in list box.

To explain it much better I have attached images and a chart to your sample qvw.

Please find the attached QVW ( made from your sample qvw attached above )

In Image 1.jpg, the drilldown stays at level L1

In image 2.jpg, the drilldown moves to level L2 automatically when only one value is selected in listbox.

However, I do not want that to happen unless I make a selection on the drilldown.

I hope I am have been more clear this time regarding what I need.

To motivate, I will award double points ( if I can ) and max stars and feedback if this solved .