Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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

Thanks for all your help

View solution in original post

12 Replies
Not applicable
Author

Any ideas?

Clever_Anjos
Employee
Employee

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

Not applicable
Author

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.

JonnyPoole
Employee
Employee

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.

thakkarrahul01
Creator
Creator

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)

Clever_Anjos
Employee
Employee

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

Not applicable
Author

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

JonnyPoole
Employee
Employee

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.

Not applicable
Author

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