Pct of total of each dim

[alec1982]

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

[alec1982]

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

[Anonymous]

can you also share your QVF file

[sunny_talwar]

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

[alec1982]

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.

[sunny_talwar]

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

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[alec1982]

thank you for the help!