QlikView into QlikServer formula problem?

[craz123]

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!

[Anil_Babu_Samineni]

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.

[Mark_Little]

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

[craz123]

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 😕

[craz123]

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.

[jyothish8807]

Hi Chris,

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

Br,

KC

[craz123]

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

[Mark_Little]

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

[Anil_Babu_Samineni]

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

[Clever_Anjos]

Let me check

count([Reference Number]) works

count(distinct [Reference Number]) does not?

could you attach a sample?

[Colin-Albert]

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