Table Creation Help

[richardm90]

Hi All,

I'm trying to create a table in Qlik Sense to show the number of patients each month and how their appointment was booked as below:

Source	Feb 2018	March 2018
Phone
Email
Web Form

I created the Month columns as measures. Below is the formula for Feb 2018 which counts the total number of appointments and filters those that were booked in Feb.

Count(

{<[Submission date.autoCalendar.YearMonth]={"2018-Feb"}>}

[Submission date])

How do I also filter it by each source?

Thanks,

[rubenmarin]

Hi Ric, the 3 first IDKpi (1, 4 and 5) can share the same IDKpi, set the IDKpi of those three to '1' (with different description for each).

You can also add a sortKPI field to sort the descriptions by expression: Min({1} sortKPI)