Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
brijeshvma
Partner
Partner

100 % stacked bar chart in qliksense with set analysis condition

Hi All ,

I Have a Two Dimension

Date  and TAB

and Expression :

Count(distinct{<Category= {'home'},Action={'scrol'}>} ID)

/

Count(distinct total <Date> {< Category= {'page'},Action={'open'},

Url={'estate_*','buy'}>} ID)

But i am not getting an 100% Bar chart .. Kinldy Help me for the same

2 Replies
swuehl
MVP
MVP

Your set analysis filter for the numerator is different from the denominator.

This might explain that the TOTAL<Date> Count does not match the sum of the single numerators.

Also, using DISTINCT qualifier might lead to the sum of single numerators be higher than the denominator, if the TAB dimension values share IDs.

In short, it's hard to tell what is going on or to give any advice without knowing your data model and data.

smgt90
Contributor II
Contributor II

I had the same problem as you and I just removed the distinct formula and it worked. 

In my case there was no issue removing it because the set analysis made the values unique.