Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why same data counts different in Table and bar chart?

Could you please let me know, why I am seeing different counts in bar chart and table?

In bar chart 2 fields are blank for Business Unit but it is showing 4 in bar chart.

Also bar chart is showing 2 counts for "f" Reporting Unit although it is only 1 in table?

I am attaching app too, which has script and visualization too.

I highly appreciate your help ❤️

Here's the code.

Cost:
LOAD
    User_Name,
    First_Name,
    Last_Name,
    BU,
    RU,
    Std_License,
    "Cost Point"
FROM [lib://QlikHelp/QlikHelp_2017_V1.xlsx]
(ooxml, embedded labels, table is Sheet1);

M:    //Code for User_Name with Maximum "Cost Point"
inner keep load 
    "User_Name" as ID,
     LastValue(BU) as [Business Unit],  //fetch last value from a record having multiple values
     LastValue(RU) as [Reporting Unit],
     LastValue(Std_License) as [License Type],
     LastValue(First_Name) as FName,
     LastValue(Last_Name) as LName,
    max("Cost Point") as MaxCostPoint 
resident Cost 
Group By "User_Name"
Order By "User_Name","Cost Point" ;  //sort in ascending order


Repeated_User:    //Code for eliminating repeated users
Load Distinct
ID,
FName,
MaxCostPoint,
[License Type],
LName,
Left(FName,5)&' '&Left(LName,5) as Name,  //fetch first 5 character from First and Last Name
[Reporting Unit],
[Business Unit]
Resident M
Order By MaxCostPoint desc;

Z1:
Load *,
  if("Name" = Previous("Name"),'Repeated', 'Unique') as "Repeated User"  //search if similar user exist, if exist,
                          //it falls in repeated user category, Unique oterwise
Resident Repeated_User
//Where "Name" <> Previous("Name")
Order By Name;
Drop Table Repeated_User;

0 Replies