Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filter not working properly for a percentage of calculation

Hi,

I am trying to create a bar graph that shows only email type responses and percentages for each score.

Type = format (paper or email)

BVQ2 = Score of 1 through 5

IF(Type='email',IF(BVQ2<>'',Count(BVQ2)/Count(TOTAL BVQ2)))

This formula works when I have the filter set on email, but the graph changes when I click on paper. I've tried a set analysis, but the percentage of calculations were not working properly:

IF(BVQ2<>'', COUNT({<Type={"email"}>} BVQ2)/  Count( {<Type={"email"}>} Total BVQ2 ))

Also, when I click on the  "show null values" box, it still shows null values.

2 Replies
MVP
MVP

Re: Filter not working properly for a percentage of calculation

Try this:

Count({<Type={'email'}, BVQ2 = {'*?'}>} BVQ2)/Count({<Type={'email'}, BVQ2 = {'*?'}>} Total BVQ2)

Not applicable

Re: Filter not working properly for a percentage of calculation

Worked great! Thanks!