Bar chart values change after drill down

[#1]

Hi, I have created a bar chart with the following things as chart parameters.

Dimension:

=if(Date([Scanner1])< Today(1)-90,'Scan1',
if(Date([Scanner2]) < Today(1)-90,'Scan2',
if(ScannerVal>0,'Good Scan')
where Scanner1 and Scanner2 are Date values in a column and ScannerVal is a number

Expression:

Count(Distinct([Application ID]))

The bars look good with the exact numbers on them. But when I drill down into each bar, the bar, instead of evaluating just that particular condition, evaluates other conditions and gives a different number.

For Example, if the bar chart in a group shows Scan1 as 40, when I select Scan1 bar, its value changes. I am sure that a single application could satisfy more than one condition in my dimension.

How do I solve this problem?

[hemhund2016]

Hi Dheeraj,

can you attach the sample qvw?

1. Did you create the Drill down group?

2. If you are using Drill Down group, you may need to use GetCurrentField(DrilldownGroup) function

Thanks,

Hemanth.

[swuehl]

Try a calculated dimension like

=Aggr(

if(Date([Scanner1])< Today(1)-90,'Scan1',
if(Date([Scanner2]) < Today(1)-90,'Scan2',
if(ScannerVal>0,'Good Scan')))

,[Application ID])

This may or may not work. As with many QV issues, it's necessary to know the data model and data to find the correct expressions.

So if above does not resolve your issue, please post a sample QVW (which could contain mock up data).