Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alec1982
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
vinay_bangari
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
alec1982
Valued Contributor II

Re: Pct of total of each dim

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

vinay_bangari
Valued Contributor III

Re: Pct of total of each dim

can you also share your QVF file

MVP
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?

alec1982
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
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?

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

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

alec1982
Valued Contributor II

Re: Pct of total of each dim

thank you for the help!