Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
userid128223
Creator
Creator

chart help

so i have following field

StudentIDDateStampTimeStamp
Eric3/22/2018
3/22/2018 3:01PM
Eric3/22/20183/22/2018 5:04 PM
Eric3/22/20183/22/2018 9:05 PM
Paul3/5/20183/5/2018 8:05 AM
Paul3/5/20183/5/2018 2:00 PM
Paul3//5/20183/5/2018 6:06 PM

Combo chart:

dimension: StudentID & DateStamp

expression: count(TimeStamp)

My issue is that my date fields is not distinct and its not charting properly. How can i make dimension to only show distinct DateStamp

4 Replies
sunny_talwar

You can resolve this in script or use a calculated dimension

Script

Date(Floor(DateStamp)) as DateStamp

CalculatedDimension

Date(Floor(DateStamp))

userid128223
Creator
Creator
Author

Thanks

And how would you write expression that counts how many times Student access system on that date.

userid128223
Creator
Creator
Author

it shows total count, instead of per date total.

sunny_talwar

Not sure what you mean? For the sample, what is the expected output?