Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am creating a simple table chart without any measures in qliksense. I have attached a screenshot to show you the intented format of the chart. The first column 'Frequency' is a Valuelist dimension, whereas the remaining fields are pulled from the data model.
Also to add, I have precalculated the Frequency values in the data model. However, I am not using it because the requirement is to keep the Frequency column static i.e. shouldnt allow the user to select the Frequency values.
Therefore, the challenge I am facing is with the calculated dimension expression for rest of the columns.
@sunny_talwar @Kushal_Chawda Could you please help me with it.
Many thanks !
Hi, if frequency is a valuelist it means that you have set manual fixed values, so maybe you can use something like
Pick(Match(ValueList('0','1-2','1-3'...),'0','1-2','1-3'...)
,Count({<Frequency={'0'}>} FieldToCount)
,Count({<Frequency={'1-2'}>} FieldToCount)
...
)
Hi, if frequency is a valuelist it means that you have set manual fixed values, so maybe you can use something like
Pick(Match(ValueList('0','1-2','1-3'...),'0','1-2','1-3'...)
,Count({<Frequency={'0'}>} FieldToCount)
,Count({<Frequency={'1-2'}>} FieldToCount)
...
)