different values in minutes

[ITStagiair]

Hey I am new to Qlik Sense. I have a question. I have got my dashboard as you can see in the file, but as you can see the value does not add up per minute. Even when there are more than 1 values in a minute it gets divided in different rods. I want to get the value of every minute together in 1 rod. as example if there are now 3 different rods for 1 minute, I want to change that in 1 rod with the value of 3. I do not know if i am clear enough, if you need more explanation you can ask it. 

[marcus_sommer]

If you want to display the data on minutes you will need to use minute or a minute-related dimension. This means something like:

minute(YourTimestamp) as Minute

or maybe

timestamp(floor(YourTimestamp, 1/24/60), 'DD.MM.YYYY hh:mm') as TimestampWithoutSeconds

- Marcus

[ITStagiair]

I added the timestamp(floor(YourTimestamp, 1/24/60), 'DD.MM.YYYY hh:mm') as TimestampWithoutSeconds, but I have a problem. when I add it on the diagram it doesnt work. And when I put it in a table it does not give me any valuables

Do I need to put the code in a new LOAD or can I put it in my current LOAD?

[marcus_sommer · Accepted solution]

You need of course adjust it to your real field-name - YourTimestamp is just an example. Beside this is timestamp()  a formatting-function and if it returned NULL it means that the content isn't numeric else a string. In this case you need to convert the field before applying any rounding/formatting, for example with something like:

timestamp(floor(timestam#(YourTimestamp, 'YourFormatPattern'),
1/24/60), 'DD.MM.YYYY hh:mm') as TimestampWithoutSeconds

- Marcus

[ITStagiair]

Thankyou, now I see the value in the table, but I have another question. I have a line diagram but in the period 10:20 to 11:00 the value needs to be 0. but because it is a line diagram it goes slowly down and stays at value 1.  can you help me  visualize the 0 values better. I want the minutes with 0 value to be at 0 and not at 1. 

[marcus_sommer]

I assume that these values aren't really 0. You may check the real values by using a table-chart for it.

- Marcus

[ITStagiair]

I looked it up, and it needs to be 0. it does not show in the table-chart too. 

 

 I want the line between 00:45 and 06:00 to be a straight line with the value of 0. maybe you can help me further with this information.

[marcus_sommer]

It looked as if there are timely dimension-values but no values for the measure. I think displaying 0 could become quite difficult and may need an appropriate populating of these data within the data-model.

Another approach may be to hide these NULL's within the object-properties which would mean that there no values between 00:45 and 06:00 which wouldn't be really wrong but may it more difficult to detect gaps between the times.

Further you could try to adjust the line-color to transparent with something like argb(0,0,0,0) for these non-exists measure-values which would mean that nothing is displayed and the gap remained.

- Marcus