Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

calculating measure based on dimension's field

Hello,

I have Status as Dimension and Clicks as Measure.

I need to calculate CR% Measure = Click / Clicks <view_site>:

Screenshot_8.jpg

When I try to build a straight table with the following formula:

CR% =

     sum( clicks) /

     sum( {<status={'view_site'}>} clicks),

It returns:

Screenshot_9.jpg

What is the correct way to make it happen?

Thank you!

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: calculating measure based on dimension's field

maybe this:

sum( clicks) /

sum( {< status={'view_site'} >} total clicks)

3 Replies
agigliotti
Honored Contributor II

Re: calculating measure based on dimension's field

maybe this:

sum( clicks) /

sum( {< status={'view_site'} >} total clicks)

ziabobaz
Contributor II

Re: calculating measure based on dimension's field

of course, you are right, I forgot about 'total' )

thank you!

agigliotti
Honored Contributor II

Re: calculating measure based on dimension's field

great!

you are welcome.

Community Browser