Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Haarika
Partner
Partner

Table chart with ValueList function

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 !

 

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

1 Reply
rubenmarin

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

View solution in original post