Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
4th Column: 3rd Column minus 2nd Column
But if I select month, not select quarter, say, select month of March, then in above table,
the 2nd and 3rd 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
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