Table chart with ValueList function

[Haarika]

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 !

[rubenmarin · Accepted solution]

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)
  ...
)