I am very new to Qlik Sense. I have this data where I need to group each of the fields and measures (columns) into common categories and then present the data.

[Anonymous]

Base Data (Uploaded in my App)                                    Calculated Data from Base Data (How to calculate this using Qliksense?)

Office              Rating                                                    Office        Compliant       Non-Compliant      Compliant with Review Issues

GTA                Compliant                                                 GTA                 1                           1                                0

GTA                Non-Compliant                                         Montreal          2                           0                                0

Montreal          Compliant                                                Vancouver       0                           1                                1

Vancouver      Non-Compliant                                         Calgary            0                           0                                0

Calgary          Compliant with Review Issues

Vancouver      Compliant with Review Issues

Montreal        Compliant

Then I want to present the Calculated data in as a percentage in Qlik Sense Bar Chart.

Can someone please explain me if this is even possible and how to go about it?

Thanks,

[jwjackso]

!

If this is your data:

Data:

Load * Inline [

Office,Rating

GTA,'Compliant'

GTA,'Non-Compliant'

Montreal,'Compliant'

Vancouver,'Non-Compliant'

Calgary,'Compliant with Review Issues'

Vancouver,'Compliant with Review Issues'

Montreal,'Compliant'

];

You can use a formula like  Count({$<Rating={'Compliant'}>}Rating) to get a count and display in a chart.

[Digvijay_Singh]

May be something like this -

Dimension - Office

Measure 1(Compliant) - Count({<Rating={'Compliant'}>}Rating)

Measure 2(Non-Compliant) - Count({<Rating={'Non-Compliant'}>}Rating)

To calculate %, you would need to divide the above measure value with total rating values like this -

Count({<Rating={'Compliant'}>}Rating)/Count(TOTAL Rating)

[Anonymous]

Thank you for your reply. How do I present the data in grouped bar charts with ratings measures (compliant, Non-compliant etc.) in X axis and different offices under different bars? The bar chart option in Qlick Sense dosen't give me this kind of chart. Please see the example below for what I want.

[Anonymous]

Thank you for your reply. How do I present the data in grouped bar charts with ratings measures (compliant, Non-compliant etc.) in X axis and different offices under different bars? The bar chart option in Qlick Sense dosen't give me this kind of chart. Please see the example below for what I want.

[pawwy1415]

Hi,

Try this extension

https://github.com/NielsLindberg/Qliksense.Extension.amWaterfall