Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please find attached solution if someone is looking for this thread.
Thanks for all your help
Any ideas?
Drill down suppose to have an hierarchy (Country > State > City), I can´t figure out what kind of drill down are you talking about
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.
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.
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)
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
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
];
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
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.
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