Dynamic Columns and calculation

[ronnyhu]

Hello,

I am new to Qliksense and need your help to solve following problem:

In my Qliksense project for Imaging dashboard, I have some dimensions:

Hospitals

Departments

Specialties

Patient Types

Years

Quarters

Months

A table shall be built as follows:

If I select a quarter, say, Jul-Sep, and select years, say 2020 and 2021, then the table needs to be shown as below:

1st Column: Department Name

2nd Column: Total Exams, ie, Count(Exam) of selected quarter of 2020,

3rd Column: Total Exams, ie, Count(Exam) of selected quarter of 2021,

4^th Column: 3rd Column minus 2nd Column

But if I select month, not select quarter, say, select month of March, then in above table,

the 2^nd and 3^rd column shall show total exams for month of March of 2020, 2021, the 4th column shall show the difference of 2nd and 3rd column, that is, the difference of total exams between March of 2020 and March of 2021.

If other dimension selection changed, eg, hospital, Specialties, etc,. then the value of above table shall change accordingly.

How to do this Dynamic Columns and calculation?

Thank you very much for your help.

Kind Regards

Ronny

[Andrew_Delaney]

It sounds like you may want to use a drill down for going from quarters to months.

This tutorial popped up with a quick google. Not had a chance to review it myself but hopefully it will give you a start https://www.youtube.com/watch?v=-j8pU1Z7YEM