Create Bar chart with information from different columns

[CarlosGarza]

Hello i´m new in qlik sense.

I want to create a bar chart in which it search from different columns the value 'No', i have created one using the 15 measures that it allow me to, but i am still left with 2 other columns to add from my file and i can´t  sort it as it is on different measures, and not in a dimension.

this is the source file where i have the different columns and what to count in every columns the 'No' 

This is the expression i am using in the measurement but i don´t think it will help with what i want to do

Thanks a lot for reading this.

[lorenzoconforti]

Best way is to do a crosstable in your load script to convert those field names into a dimension; then your chart will be much easier to implement

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...