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

output of the expression differs after drilling down the hierarchy

Hi All,

I am using Qlikview 11.2 version.

I have straight table , in which i have 2 dimensions and an expression.

The Dimensions used are, Department and team.

expression used is :

if(Not IsNull(Department),

       Num (

             RangeSum (                

if([sale] >= 1, Count ({$<[sale] = {'>=1'}>} DISTINCT period),0)

               /

(NoOfworkingDays_in_month)                   

             )

       , '#.##0,00%'),

       (

      

       Num (

RangeSum (if(IsNull(sale),0,

                                       Avg (

                                                       Aggr (   

Count ({$<[sale] = {'>=1'}>} DISTINCT Period)

                                                                       /

(NoOfworkingDays_in_month)

,  cod_dept, year)

                                       )             

))

       , '#.##0,00%')

       )

)

The standard table structure is as shown below:(Department A has been selected),

DepartmentTeamExpression
A120
A230
A340

But when i select the filters Department: A nad Team:1  the following will be displayed:

DepartmentTeamExpression
A110

Ideally the value should remain 20.

this seems to be so weird.

Can some one please let me know Why does the value of the expression change?what is the culprit?

I have no triggers applied on this sheet.

Thanks,

1 Reply
Gysbert_Wassenaar

Please post a document that demonstrates the problem.


talk is cheap, supply exceeds demand