Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I seek advice for a problem I encountered while developing a bar chart for an app using Qlik Enterprise.
The desired end product I would like to develop is a clustered bar chart for the revenue tracking of the 3 most recent weeks, across different brands. In short,
Current problem
I thought of using set analysis but understand that it must be coded in an aggregation setting, which seems not applicable in this case, as I feel this seems to be more of a calculated dimension issue.
As I tried to derive a calculated field/dimension, I am also unsure of how to treat/code with the field FiscalWeekName (is it still date-type?), as it is a grouping of dates. The code used in the data load editor for generating the Fiscal Calendar table (and hence the FiscalWeekName) is attached for reference.
Is there any way to go around/change the limiting by measure to dimension values instead? Or how can I create a new dimension which limits the FiscalWeekName to the (relatively) 3 latest weeks?
Pardon me if this is a simple problem, as I am still less than 1 month old into Qlik Sense. Any advice or suggestion will be appreciated and thanks for taking the time to read this long question.