# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor

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

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,

Tags (5)
5 Replies
Valued Contributor

## Re: 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.

!

Data:

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.

Honored Contributor III

## Re: 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.

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)

New Contributor

## Re: 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.

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.

New Contributor

## Re: 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.

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.

Contributor II