Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nbless
Contributor
Contributor

Combine dates as dimension

Hello community,

I'm currently struggeling with a visualization and need some help.

 

As a basis I have three columns from a data table:

-ProductionDate (DD.MM.YYYY DateFormat)

-SalesDate (DD.MM.YYYY DateFormat)

-ProductName (String)

 

Now I'd like to show a line diagramm with the date in MM.YYYY format on the y-axis and two line graphs, one for the count of products per production month (ProductionDate) and one for the count of products per sales month (SalesDate).

I found the following formula for getting the desired date format:

 

=(Date(monthstart([SalesDate]), 'MMM-YY'))

 

 

But I dont know how I can combine both dates from "ProductionDate" and "SalesDate" as a dimension for the diagram.

 

Can anyone help me out?

Best regards 

Nils

 

 

 

1 Reply
Dalton_Ruer
Employee
Employee

You can simply concatenate the two values with the & operator. In this example I concatenate the two fields and have a hyphen in between the resulting value

ProductionDate & '-' & SalesDate as CombinedDate;

If you need to do any manipulation of the fields in your load script you can either repeat those expressions like you did above for each field or do a Preceding Load to avoid having to redo expressions. Which is a little advanced but well documented here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/prece....