Time Series visualization

[MoFahsi]

hello everybody,

i am a beginner in the Qlik Sense world and i have a question concerning charts with time series. So, my question is: I have a time stamp field in my data in milliseconds like in this form for example "2010-01-08 10:30:15.567" and other data fields like "Unique-ID", "Price" and "Produkt"..etc. I have duplicates in the Timestamps in my data but with different "Unique-ID" like in the table bellow:

Unique-ID	Time Stamp	Price	Produkt-ID
1	20.08.2020 05:31:31.052	25,1	AF
2	20.08.2020 05:31:31.069	23	AX
3	20.08.2020 05:31:54.768	10	AS
4	20.08.2020 05:31:54.768	23,2	AE
5	20.08.2020 05:31:54.768	24	AX
6	20.08.2020 05:43:16.292	12	AF
7	20.08.2020 05:43:16.292	12	AV
8	20.08.2020 05:43:20.342	14	AX

The problem is, when i try to show the data in a combi chart with the time Stamp as a dimension in the x-axis, i get no points for example for the time stamp "20.08.2020 05:31:54.768". What i want is to visualize all the different rows in this example (3 rows at the time stamp "20.08.2020 05:31:54.768") without any aggregation.

I would be very thankfull, if you have any idea to handle this subject.

Kind regards.

M.Fahsi

[Dalton_Ruer]

The problem is that if you are showing a dimension value like the PRICE field but you really have multiple values for it, Qlik doesn't know WHICH one to show. So you must either add the second dimension for the product, or you must use an aggregate function (MIN, MAX, AVG etc.) 

If you use add a second dimension for the product you can get the multiple points, but with the sample data there is no series except for one of the products since not all products have values for all Timestamps. You could fix that in your data load if you desired. 

[MoFahsi]

Hello Mr. Dalton Ruer,

first of all thank you sincerly for your reaction. I do realise that Qlik need an aggregation funktion to handle duplicates on the time stamp axis but or a second dimension to diffenciate between records with the same time stamp, but waht i want to do is to visualize the unique records "unique-ID", even if they have the same timestamp. In my case it dosen't make sense to use an aggregatoion because the records with different Unique-IDs in my data sample are unique. Concretely due to the logic of my data i am using a combi chart diagram and i am trying to achieve something like bellow:

I would be very thankfull if you or somebody in the community has any idea in this subject.

Kind regards,

M.Fahsi