Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Drill Down in Bar Charts without dimension

Hi Team,

I have 3 expressions say:

count(sales),count(profit),count(dates)

When I add these 3 expressions in bar it shows the result fine but unable to drill down.

Please provide your suggestions.

Thanks,

SV

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Drill Down in Bar Charts without dimension

Please find attached solution if someone is looking for this thread.

Thanks for all your help

View solution in original post

12 Replies
Highlighted
Not applicable

Re: Drill Down in Bar Charts without dimension

Any ideas?

Highlighted
Employee
Employee

Re: Drill Down in Bar Charts without dimension

Drill down suppose to have an hierarchy (Country > State > City), I can´t figure out what kind of drill down are you talking about

Highlighted
Not applicable

Re: Drill Down in Bar Charts without dimension

Sorry for mis interpretation. I want to be able to click the bar and should be able to show that single value.

Currently even if i click, it doesnt drill down.

Highlighted
Employee
Employee

Re: Drill Down in Bar Charts without dimension

What would be the desired effect ?  You click the sales bar ... and what breakdown would you like to see ?

You could add a data island with 3 values :

load * inline [

Measure,Link

Sales,1

Profit,1

Dates,1];

And then add a new field to your fact table:

change:

Load

     *

from <>

to:

load

     1 as Link,

     *

from <>

Add 'Measure' as a dimension to your chart , and change your expression to:

if( Measure='Sales', count(Sales), if( Measure = 'Profit', count(Profit), count(Dates) )

then if one measure is selected you can capture it with getselectedcount(Measure) = 1

You could conditionally show a 2nd dimension for example.

Highlighted
thakkarrahul01
Contributor

Re: Drill Down in Bar Charts without dimension

As cleveranjos‌ said, you should be looking for drill down/cyclic dimension hierarchy. Your expectation doesn't sound reasonable and didn't got what you actually want to achieve with count(sales),count(profit),count(dates)

Highlighted
Employee
Employee

Re: Drill Down in Bar Charts without dimension

That´s because you have 3 expressions, QlikView by design does not make selections on expressions but dimensions.

A possible workaround is creating a "fake" dimension like jpe‌ suggested

Highlighted
Not applicable

Re: Drill Down in Bar Charts without dimension

Hi Jonathan,

I couldn't really get the exact one. Below is what i have:

Table:

LOAD * Inline [

ID1,ID2,ID3,Date

1,18,31,12/12/2014

29,15,31,11/12/2015

10,13,1,10/12/2015

12,13,1,11/19/2015

];

Capture.PNG

I am unable to click on ID1 or ID2 (Blue or Red bars)

I want it to be clicked and showed, currently dimension is empty

Highlighted
Employee
Employee

Re: Drill Down in Bar Charts without dimension

hmm... i think you deviated from the framework i laid out.  I suggested adding 2 fields to a new table. The first field is the measure name, the 2nd is a constant value to link the measure to all the records in the data model.

There are 3 rows in this table for each measure. (3 measures)

You created a different field for each measure which is different. I think you need to start by changing that .

Table:

LOAD * Inline [

Measure,Link

ID1,1

ID2,1

ID3,1];

...then see if you can follow the next step too.

Highlighted
Not applicable

Re: Drill Down in Bar Charts without dimension

I am sorry for missing it out. I took a sample with fields as ID's and tried to show you an example.

Table:

LOAD * Inline [

ID1,ID2,ID3,Date

1,18,31,12/12/2014

29,15,31,11/12/2015

10,13,1,10/12/2015

12,13,1,11/19/2015

];

Table:

LOAD * Inline [

Measure,Link

ID1,1

ID2,1

ID3,1];

Even if I add these it doesn't work. Can you please post a sample if possible,  sorry if am asking for more but I am stuck