Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get column in a table depending on the selections of a list box?

Hello all

I need to calculate a table, and one column depends on the selection of a list of values that are summarized as a new column; the values that are not selected, should be visualized as extra columns at the same level:

My data:

RunnerActtimes
Runner11km1
Runner15km2
Runner220km2
Runner35km1
Runner31km3
Runner25km2
Runner23km3
Runner13km2

The field tha the end user uses todefine the field "Long distance"

Long distance
1km
5km
20km

The resulting table, when end user selects in "long distance" field the value 5km and 20 km

Long Distance1km3km
Runner1212
Runner2403
Runner3130
0 Replies