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!

[jyothish8807]

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,

KC

[craz123]

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?

[jyothish8807]

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,

KC

[manoj217]

Else try with

=count(DISTINCT( [Reference Number]))

check with web view

[Anil_Babu_Samineni]

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

[Mark_Little]

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

[craz123]

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

[craz123]

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

[craz123]

Hi Anil,

What do you mean?

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