Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Not applicable

drill down

I have created the barchart and drill down for that, in first level its giving the values sum for each value in x-axis. but not providing the same sum for next level. why this may I know?

If any body faced this problem earlier please let me know or if you aware about this please let me know.

14 Replies
dan_sullivan
Contributor II

Re: drill down

can you provide more details?  screenshots or the qvf?  by nature of the drill down you should get different results.  you will be getting the subset of the item you have drilled upon.

beck_bakytbek
Honored Contributor

Re: drill down

sadasiva
Contributor II

Re: drill down

Hi,

For drill down are you using hierarchy? then you are selecting drill down from from Fliter pane or the bar itself?

Can you give some clarification, so that i can give more insights?

Regards,

Sadasiva

Not applicable

Re: drill down

Hi,

I am taking two columns into Drill Down from fact table. and expression column from fact table only.

Drill down columns:

1. Column1

2. Column2

and expression if year is greater than zero and noof failures =0

if(

GetSelectedCount(Year)>0,

(if(NumOfFailures=0,

(Sum({<Year={'$(vPrevYr)'},EquipmentCategory ={'LOCOMOTIVE'}>}AssetMiles)

/

Sum({<Year={'$(vPrevYr)'},EquipmentCategory ={'LOCOMOTIVE'}>}NumOfFailures)),

(Sum({<Year={'$(vMaxYr)'},EquipmentCategory ={'LOCOMOTIVE'}>}AssetMiles)

/

Sum({<Year={'$(vMaxYr)'},EquipmentCategory ={'LOCOMOTIVE'}>}NumOfFailures)))

)

bellamae
Valued Contributor

Re: drill down

Can you confirm what happens when you select an option from column 1? Does the chart then change to show Column 2?

Not applicable

Re: drill down

yes, It is showing column 2. But the problem is the total of result  is different for second level.

example: In first level column1 value A in x- axis total of A is 500. when I am selecting A in first level it will go to second level, the values of A-axis is 1,2,3,4 total of these value is not equal to 500.

sadasiva
Contributor II

Re: drill down

Hi,

This maybe because you are having null values in the Columns. Try to uncheck Show null values in the dimension properties.

Regards,

Sadasiva

Not applicable

Re: drill down

Hi Sada,

I have unchecked the null values, even though I am getting that issue.

Thanks,

sadasiva
Contributor II

Re: drill down

Hi,

Try to make a pivot chart with the same and cross check the numbers with source. this may helps.

Regards,

Sadasiva