Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Table which displays 24 hours of the day

Hi all,

Table header should be the hours of the day and the first row should have the count of completions, second row count of signups,

I have a date in format - MM/DD/YYYY HH:MMSmiley FrustratedS AM/PM.

I have a expression for counts : count(course_completed)

Count(user_signed)

but this should display in hour wise when i select a date through date picker.

If number of count completion in 1'O clock is 10 then it should display in column 10.

Please help over this.

Regards,

Pramod

Tags (1)
2 Replies

Re: Table which displays 24 hours of the day

I think first You need to create the Hour Field in script as

Hour(YourDate) as Hour

Now You can select the Particular Date & Corresponding Hour also to get the result

Not applicable

Re: Table which displays 24 hours of the day

Not quite sure what you want, but you could use a PivotTable, with HOUR([DateField]) as the column dimension and perhaps DATE([DateField],'MM/DD/YYYY') as the row dimension - then your two measures.

It would give you the hours of the day along the top - however, if the count in 01:00 is 10, it would display 10 in the second column - not the tenth.