Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Waïl_Riachi_Sanofi
Creator
Creator

Data recognition problem

Hello ! I uploaded an Excel file to Qlik which has 50 "active" and 38 "inactive" but when I create the QlikSense indicator I find 47 and 41. Does anyone have an explanation? Here is the formula used: Count({<Active={'Active'}>} ([JUN-MAR.Active]))

Wal_Riachi_0-1629816899935.pngWal_Riachi_1-1629816915303.png

 

2 Replies
stevejoyce
Specialist II
Specialist II

are you doing any joins in your load script?

Can you share the excel file & load script?

Waïl_Riachi_Sanofi
Creator
Creator
Author

I didn't use the load script I load directly with the data manager. Here is my joins (by GILES number)

 

Wal_Riachi_1-1629878616779.png

Wal_Riachi_2-1629878633864.pngWal_Riachi_3-1629878675208.png