Qlik Community

Qlik Sense Cloud Discussions

jonnieyacoub
Contributor

Formula in KPI visualization

Hey Qlikkers,

Im trying to get the following expression in one KPI visualization. Is it possible to get the first two set analysis counts in one?

count({<[type]={'deal'},

[source]-={'Via verhuurder'},

[date]={'>=01/03/2017'}>}

[type])

+

COUNT(DISTINCT{<[fee_type]={'commission'},

status_contract_renter_signed={'>=01/03/2017'},

client_contract_status={'final'}>}

client_contract)

/

Count({<[type]={'lead'},

source -={'Via verhuurder','Eerder geholpen'},

date={">=01/03/2017"}>}

type)

2 Replies
Employee
Employee

Re: Formula in KPI visualization

Hi Jonnie, (just to get some clarity)

Thanks for your question. Are you trying to just reduce the formula to make it easier to read?

Are you having any issues with the result, or is the result OK?

Thanks

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Mike T

Qlik

Regards,
Mike Tarallo
Qlik
jonnieyacoub
Contributor

Re: Formula in KPI visualization

hi sir Tarello,

The formula is working but it is showing the wrong result. I want to show the conversion rate %...

The formula below shows me the right result. but when i want to devide these counts by an other count, it gives me the wrong result

count({<[type]={'deal'},

[source]-={'Via verhuurder'},

[date]={'>=01/03/2017'}>}

[type])

+

COUNT(DISTINCT{<[fee_type]={'commission'},

status_contract_renter_signed={'>=01/03/2017'},

user_id={'*'},

client_contract_status={'final'}>}

client_contract)

Community Browser