topic Re: QlikView into QlikServer formula problem? in QlikView

QlikView into QlikServer formula problem?

craz123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Having some trouble with this formula:

=count(DISTINCT[Reference Number])

It works when I work on it in my localized version on my desktop.

Once I publish into QlikServer only this formula does not work... just shows a '-'.

Anyone have any insights to it? All my other graphs, data work fine just that this pesky one...

Appreciate any thoughts / comments / advice. Thanks!

Re: QlikView into QlikServer formula problem?

jyothish8807 — Tue, 23 Oct 2018 04:48:09 GMT

Hi Chris,

Try giving space between distinct and field name.

=count(DISTINCT [Reference Number])

else do you have any triggers set on the dashboard ? try opening the dashboard in both Ajax and plugin version and see the difference.

Br,

Re: QlikView into QlikServer formula problem?

craz123 — Tue, 23 Oct 2018 04:59:15 GMT

Thanks for the response.

Publishing is done by another team within my org, I will check with them.

On my end besides adding a space between distinct and [attribute] anything else I can possibly do to debug it?

Re: QlikView into QlikServer formula problem?

jyothish8807 — Tue, 23 Oct 2018 05:30:28 GMT

May be you can turn on web view and see if you find any difference. Not sure if it will be helpful.

Since your expression should work if you have space between distinct and field name.

Br,

Re: QlikView into QlikServer formula problem?

manoj217 — Tue, 23 Oct 2018 06:14:56 GMT

Else try with

=count(DISTINCT( [Reference Number]))

check with web view

Re: QlikView into QlikServer formula problem?

Anil_Babu_Samineni — Tue, 23 Oct 2018 06:44:28 GMT

Hi Chris, For me indicating as "Wrong Application placed". Can you check if there are any versions in your Production?

Re: QlikView into QlikServer formula problem?

Mark_Little — Tue, 23 Oct 2018 07:40:21 GMT

Hi,

The Set Analysis seems fine to me. Could it be done data being different on your machine and production?

I.e. Different Qvds?

Mark

Re: QlikView into QlikServer formula problem?

craz123 — Tue, 23 Oct 2018 09:54:43 GMT

webview works perfect when I turn the mode on.

Just that once it goes it production / live URL - it just puts a "-" and it auto bolds...

have tried the Formula changes extra bracket, space etc.. Works fine in local.. but no in server. That's the part im having trouble with debugging

Re: QlikView into QlikServer formula problem?

craz123 — Tue, 23 Oct 2018 09:55:30 GMT

Data source / Data file is the same. So that's one off the list.. 😕

Re: QlikView into QlikServer formula problem?

craz123 — Tue, 23 Oct 2018 09:56:14 GMT

Hi Anil,

What do you mean?

Each time we replace the version we override the existing with the new one. Do you mean that?

Re: QlikView into QlikServer formula problem?

Anil_Babu_Samineni — Tue, 23 Oct 2018 10:40:29 GMT

I didn't mean that exactly. Is there any triggers assigned to get that number? Because, when we say version upgrade there may be problem if you have too much load of expression. You just used distinct with count. This never behave like that. Why this weird working in local? Can you re create the object and publish then we will think issue srill persist.

Re: QlikView into QlikServer formula problem?

Mark_Little — Tue, 23 Oct 2018 10:46:38 GMT

Hi again,

From the screenshot is it showing that the QVD's at least have different data in, so i would look at troubleshooting on production server. The set analysis is pretty simple, so i would start by looking at the Reference Number field and make sure it shows as expected.

Mark

Re: QlikView into QlikServer formula problem?

craz123 — Wed, 24 Oct 2018 02:03:23 GMT

Field is definitely there as you can see the Total # of Responses is showing =count([Reference Number])

Once u add distinct for Unique Users count - suddenly it cannot count 😕

Re: QlikView into QlikServer formula problem?

craz123 — Wed, 24 Oct 2018 02:05:58 GMT

Object re-created, re-published. Still the same.

It was original textbox now im using a listbox to see if it will make a difference.

The thing is if you refer to the pics I attached above, Total # of Responses is showing =count([Reference Number]). But once u add distinct to it.. it just suddenly does not work.

Also, production using QlikV 12 same as my local.

Re: QlikView into QlikServer formula problem?

jyothish8807 — Wed, 24 Oct 2018 04:54:37 GMT

Hi Chris,

Are you using any extension object to show the count ? Is yes, then try plugin version on the access point once.

Br,

Re: QlikView into QlikServer formula problem?

craz123 — Wed, 24 Oct 2018 05:19:57 GMT

Hi KC,

No extension being used, everything is based off the default functions in QV.

Curious, if I publish my page without locking the sheet / leave it editable am I still able to change the formulas etc? I am currently in the midst of putting it in test server so still waiting to see if I could debug from the web URL itself

Re: QlikView into QlikServer formula problem?

Mark_Little — Wed, 24 Oct 2018 07:13:44 GMT

Hi Again,

Have you tried doing any other calculations with the field? Like a sum? or using it in other charts?

Could be interpreting it as string field? Maybe worth wrapping it in a num() in the script to rule it out?

Mark

Re: QlikView into QlikServer formula problem?

Anil_Babu_Samineni — Wed, 24 Oct 2018 08:39:43 GMT

Also, production using QlikV 12 same as my local.

This is where my doubt, Because initial reply you said it is working but deploying to Prod the same application which is not working. I am not sure, What is the issue but cuv‌ will help

Re: QlikView into QlikServer formula problem?

Clever_Anjos — Thu, 25 Oct 2018 12:07:43 GMT

Let me check

count([Reference Number]) works

count(distinct [Reference Number]) does not?

could you attach a sample?

Re: QlikView into QlikServer formula problem?

Colin-Albert — Thu, 25 Oct 2018 12:21:26 GMT

Does the document have Section Access? This may be restricting access to the data.