# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. \$300 savings extended to February 9th Learn More
Valued Contributor II

## Pct of total of each dim

hi all,

I am having challenge building a chart in qliksense to show pct of total values of each dimension

I am able to build it in QlikView (File Attached) and the values are accurate but not able to replicate in sense..

Anyone can help...

Thanks,

Alec

1 Solution

Accepted Solutions
Valued Contributor III

## Re: Pct of total of each dim

See the attached QVf file showing both charts . May be you will understand the difference.

8 Replies
Valued Contributor II

## Re: Pct of total of each dim

still not able to fix it.. I appreciate it if anyone has an idea..

Valued Contributor III

## Re: Pct of total of each dim

can you also share your QVF file

MVP

## Re: Pct of total of each dim

What is the issue you are running into? The same dimension and expressions in Qlik Sense don't work?

Valued Contributor II

## Re: Pct of total of each dim

the values of the pcts are not the same even I am using the same table as a source and same dimensions and expression

the values on QlikView are accurate and the values on Sense are wrong.

MVP

## Re: Pct of total of each dim

That should not happen, but as Vinay mentioned, would you be able to share a sample qvf where we can see the difference?

Valued Contributor III

## Re: Pct of total of each dim

alec1982

you are right both tools are interpreting in different manner. This is what the solution is instead of calculated dimension use set analysis.

your dimensions should be like this

range

name

measure:

count({\$<Active_Flag={'1'},range-={'Unknown','above \$61'}>}Active_Flag)/

count({\$<Active_Flag={'1'},range-={'Unknown','above \$61'} >}total <range>  Active_Flag)

you will get the right pct totals. The reason is when you give calculated dimension in qlik sense the supress null values is not working properly which could be a bug in qlik sense. Learnt a new thing from this post.

Valued Contributor III

## Re: Pct of total of each dim

See the attached QVf file showing both charts . May be you will understand the difference.

Valued Contributor II

## Re: Pct of total of each dim

thank you for the help!