Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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 belowSmiley SadDepartment 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

Re: output of the expression differs after drilling down the hierarchy

Please post a document that demonstrates the problem.


talk is cheap, supply exceeds demand
Community Browser