Table chart with ValueList function

Haarika — Sat, 03 Jul 2021 02:11:19 GMT

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 !

Re: Table chart with ValueList function

rubenmarin — Sat, 03 Jul 2021 07:47:17 GMT

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

topic Re: Table chart with ValueList function in App Development

Table chart with ValueList function

Re: Table chart with ValueList function