Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for 
Search instead for 
Did you mean: 
uko223
Contributor III
Contributor III

Percent Breakdown of a Dimension by Quarter

Hello,

 

I am trying to create a chart that display a percent breakdown of a dimension of that contains only two values by quarter. However, when I add the quarter dimension, the measure breaks down all of the quarters. See below example of it currently. 

2-19-2020 8-01-39 AM.jpg

 

If I select an individual quarter from the dimension, this is the result I am looking for. I need this breakdown across all the individual quarters.

2-19-2020 8-05-01 AM.jpg

 

This is the measure

(Count(distinct
[Order - Order Number]))
/
(Count(Total distinct
[Order - Order Number]))

 

Here is the chart I want to update to correctly display the percent breakdown by order source per quarter. As you can see, its currently aggregating across all quarters. 2-19-2020 11-55-13 AM.jpg

 

 

 

1 Reply
nisha_rai
Creator II
Creator II

Hi,

Can you share the sample data