Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Waïl_Riachi_Sanofi

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