Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Re: QlikView into QlikServer formula problem?

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: QlikView into QlikServer formula problem?

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

Highlighted
christhng1
New Contributor

Re: QlikView into QlikServer formula problem?

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 😕

christhng1
New Contributor

Re: QlikView into QlikServer formula problem?

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
Honored Contributor II

Re: QlikView into QlikServer formula problem?

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

Best Regards,
KC
christhng1
New Contributor

Re: QlikView into QlikServer formula problem?

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

Partner
Partner

Re: QlikView into QlikServer formula problem?

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?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Employee
Employee

Re: QlikView into QlikServer formula problem?

Let me check

count([Reference Number]) works

count(distinct [Reference Number]) does not?


could you attach a sample?

Re: QlikView into QlikServer formula problem?

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