topic Re: Working with percentage columns in QlikView in QlikView

Working with percentage columns in QlikView

kdmarkee — Fri, 17 Apr 2020 19:42:36 GMT

I'm sure this can be done but I haven't found the magic code yet upon my experimentation. I have an issue where based on my data model's complexity, I get odd results when counting distinct for a column and then wanting to have a "% of" on that column as well.

Here is the underlying raw data:

this is what is true:

This is what Qlik does, which in turn can make my % of bslips column wrong and the column total > 100%:

Here is what I think I need to overcome this...how do I build the blue column so I can use the column names from my expressions in my % bslips expression :

Thanks!

Re: Working with percentage columns in QlikView

kaushiknsolanki — Sat, 18 Apr 2020 10:11:45 GMT

Hi,

Qlik Should give you correct result, if you have used proper expressions.

Anyways to get the blue field you can use below expression.

Count(Total alias)

Re: Working with percentage columns in QlikView

kdmarkee — Tue, 21 Apr 2020 14:50:23 GMT

The count of alias will not work because that is not the most granular level of data in my data model. I did some more experimentation and think I have what I need. I used this get the blue column (bslip total): sum(total aggr(count(distinct [bslip]), [alias])). Now that I have bslip total and bslip count, I can use those column names in an expression to get me the correct row percentages (and correct column percentage total).