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: 
madhubabum
Creator
Creator

Pivot Table Expressions

Hi All

I have "Pivot Table"  with more than 5 expressions

Ex : Sum(Sales) , ................., Count(Sales)


In my application , If i am selecting any selection (Any Filter) it does not effect on Count(Sales) expression.

Note : Filters are doesn't effect on that particular Expression


So , How can we achieve this one ?


Thanks

Madhu

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please use this kind of expression, this will eliminate any selection

Count({1}Sales)

View solution in original post

4 Replies
Clever_Anjos
Employee
Employee

Please use this kind of expression, this will eliminate any selection

Count({1}Sales)

Kushal_Chawda

try,

Count({<Field1=,Field2=>}Sales)

madhubabum
Creator
Creator
Author

Hi Clever Anjos

I am using DrillDowngroup As a Dimension and i using the following Exp : Count({1}EquipmentId)

Here i am getting Total values right , But not a field values as mention bellow .

How to rectify this ?

madhubabum
Creator
Creator
Author

I am using  2 pivot tables :

Pivot table 1: Using Region (Drill down Dimension) &

  Expression :

count( aggr(Count(EquipmentId),EquipmentGroupName,EquipmentClassName,EquipmentModelName))

Pivot table  2: Using Group (Drill down dimension) & Expression : Count(DISTINCT EquipmentId)

Note : If i select "region" filter on multi box , The values are not matching on both pivot tables..

          (Totals are not matching on bellow Pivot two tables)

Untitled.png

So, How can i rectify this one ?

Have you have any Idea ?

Thanks

madhu