Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jordanhertl
New Contributor III

Two similar graphs/formula's. One is working...one not. Help?

QS Help!.png

Hello All...I have a line graph and a pie chart here. The pie Chart is giving me the correct score. The Green Section in the Pie chart has a percentage of 29%. These are the "good" scores, and they are just for Quarter 1 2018.  A good score is 4 or over. On the left with the line chart I have the "good" scores charted out by quarter. The Q1 2018 score on here is giving me 13%?! I am baffled. It seems like the line chart is counting the null values in the percentage where the pie chart isn't for some reason?

I am using this formula for the line chart: Num(Count({<test_measure = {">=4"}>} test_measure) /Count(test_measure),'0%')

7 Replies
mdmukramali
Valued Contributor II

Re: Two similar graphs/formula's. One is working...one not. Help?

Hi,

Maybe something like

Num(Count({<test_measure = {">=4"}>} test_measure) /Count({<test_measure = {'*'}>}test_measure),'0%')

jordanhertl
New Contributor III

Re: Two similar graphs/formula's. One is working...one not. Help?

Hello,

Thank you for the response. I am still getting the same result with that formula.

mdmukramali
Valued Contributor II

Re: Two similar graphs/formula's. One is working...one not. Help?

Hi,

Can you share sample App or Data.

Digvijay_Singh
Honored Contributor III

Re: Two similar graphs/formula's. One is working...one not. Help?

May be this -

Num(Count({<test_measure = {">=4"}>} test_measure) /Count(total test_measure),'0%')

alextimofeyev
Contributor II

Re: Two similar graphs/formula's. One is working...one not. Help?

Jordan,

which version of Qlik are you using? I can't reproduce your issue in February 2018 release.

As Mohammed said, it would help if you could share a sample app.

Alex

jordanhertl
New Contributor III

Re: Two similar graphs/formula's. One is working...one not. Help?

Qlik Sense 3.2 SR3

How can I share a sample app?

alextimofeyev
Contributor II

Re: Two similar graphs/formula's. One is working...one not. Help?

You may want to create a copy of your app first, removing sensitive and/or irrelevant data to make it lighter.

If you are using Qlik Sense desktop, then you can just take the appropriate file from C:\Users\{your username}\Documents\Qlik\Sense\Apps (or something like that).

if you are on Qlik Sense server, you have to go to QMC and export the app  - it will produce a QVF file.

Community Browser