Display multiple flags as

[vibhu22oct]

Hi,

What is the best way to display around 20 - 25 flags (0/1) for user selection in Qlik Sense? , these flags should not occupy too much space on sheet , below is the scenario with sample data

Scenario:

I have module column in data which has 0 and 1 value as shown below (attached excel sample as well)

[anat]

Try to create inline load or use applying to get desired outcome

[qv_testing]

My suggestion is that these many options will not fit on the screen. Add all module flags to the chart and place them in the container.

[pravinboniface]

1. Concatenate all the fields with a separator such as '-' and show it in one cell for eg 0-1-0-0-1-1-0 etc

2. Unpivot and show it as rows (if the number of rows is manageable)

3. If you have vizlib filter, you can show the column names on the left as a table with a checkbox.  If the user selects a column, then it appears in your main chart.  That way, you don't show by default.

[marcus_sommer]

I think I would use a crosstable-statement to transfer these n fields into two fields - the module-information and the flag-value. The user could then simply select which modules should be considered + the wanted flag-value.

Further useful could be to aggregate - as sum() and/or concat() - the flag-values in regard to a relevant KEY or a recno() which might be following steps clustered and/or scored and/or categorized ...