topic Re: Get total over Calculated dimension in QlikView

Get total over Calculated dimension

Thu, 04 Jun 2015 19:08:06 GMT

if I create a calculated dimension like below

if(charge<15000, 'Low charge', if(charge<50000, 'High charge', 'Med Charge')

and had 2nd dimension age_grp, which from load data

Now, I want to compute the % of age_grp within charge level like

count(distinct subject_id)/count(total <calculated charge level> distinct visit_key )

My question is how to add the calculated dimension in the count function.

Thanks

sunny_talwar — Thu, 04 Jun 2015 19:22:30 GMT

Will you be able to share a sample?

Thu, 04 Jun 2015 20:03:39 GMT

I create a simple example to show my question as below

sunny_talwar — Thu, 04 Jun 2015 20:42:55 GMT

This seems to work:

Count(DISTINCT [subject id])/Count(DISTINCT TOTAL <charge> [subject id])

Fri, 05 Jun 2015 02:16:45 GMT

brilliant!!!!!!!!!!!!!11