Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSenseUser2
Contributor III
Contributor III

Combine Values

I'm trying to combine [TRUCK_NUMBER]  into one value the value on the right 2011458.  Since the [TRUCK_NUMBER] changed over time, I would like to capture all the corresponding cells under one [TRUCK_NUMBER]. This Mapping Load doesn't seem to work. Is there anything I can do to combine the [TRUCK_NUMBER] into one?

 

QlikSenseUser2_0-1644352709918.png

QlikSenseUser2_1-1644353082168.png

 

4 Replies
jwjackso
Specialist III
Specialist III

It is hard to tell from your screenshot, but do you have the Applymap statement in the Load statement like

Date(Date#([BILLED_DATE],'y\YYYYMMDD'),'MM/DD/YYYY') as [BILLED_DATE],

Applymap('TRUCK_NUMBERMapping',[TRUCK_NUMBER]) as [TRUCK_NUMBER],

[COMPANY_OR_LEASED],

 

QlikSenseUser2
Contributor III
Contributor III
Author

I have it like this

APPLYMAP( '__cityKey2GeoPoint', APPLYMAP( '__cityName2Key', LOWER([REPORTING_DIVISION])), '-') AS [systemi/REVENUE_FOLLOWING_TRUCK.REPORTING_DIVISION_GeoInfo],
Applymap('TRUCK_NUMBERMapping',[TRUCK_NUMBER]),
[TRUCK_NUMBER] AS [$Truck-%Trucks.],
(Date(Date#([BILLED_DATE], 'YYYYMMDD') ,'MM/DD/YYYY')) AS [%Date-%Date.],
([TRUCK_NUMBER])&((Date(Date#([BILLED_DATE], 'YYYYMMDD') ,'MM/DD/YYYY'))) AS [%Key.]

 

 

jwjackso
Specialist III
Specialist III

So field [Applymap('TRUCK_NUMBERMapping',[TRUCK_NUMBER])] does not have the combined results?

QlikSenseUser2
Contributor III
Contributor III
Author

No, it's only showing the corresponding values of 2011458 for all now. I'm trying to get  2011458 to show the values for 2011458, 2010622, and 2010991 combined.

QlikSenseUser2_0-1644421080423.png