Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
psk180590
Creator III
Creator III

Pivot Table - Gives False Sum

Hello Everyone,

I'm facing a very strange problem with a Pivot Table.

Without Selection:

Without Selection.PNG

After Selecting the Date:

With Selection.PNG

As seen above, the Visit Count increases from 1 to 4 after selecting the particular date.(4 is the correct value present in my DB)

The Formula i have used to get the Visit Count :

sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company))


I have Date and Code as Dimensions.

TIA!!

Sai.

1 Solution

Accepted Solutions
sbobbyraj
Creator III
Creator III

try this as expression:

sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company,Code,Date))

View solution in original post

1 Reply
sbobbyraj
Creator III
Creator III

try this as expression:

sum(aggr(if(count(VisitID)>=1,1,0), %Key_Company,Code,Date))

View solution in original post