topic Re: QlikView -> Published QlikView Formula Error? in QlikView

QlikView -> Published QlikView Formula Error?

craz123 — Tue, 23 Oct 2018 02:03:16 GMT

Hi all,

Some background:

I have done a local version of my dashboard on QlikView (licensed). Had it published into QlikView Server.

In local, dashboard was working fine - formulas, graphs all good.

In server, dashboard was working fine - all except for 1 formula which gave a ' - '.

The formula behind the output for a number is: =count(DISTINCT[Reference Number])

Anyone have experience with this? And know why? Formula problem? Upload errors?

I have tried to delete the box and re-create the formula box again.. to no avail - same error.

If anyone has any experience/workarounds please let me know! Much appreciated

m_woolf — Tue, 23 Oct 2018 11:55:47 GMT

Have you looked at the Reference Number field to see if there is any data?

kkkumar82 — Tue, 23 Oct 2018 15:41:17 GMT

I guess reference number field is different in Ur local and published copy,Chech the validity of the column

craz123 — Wed, 24 Oct 2018 03:19:18 GMT

Thanks for the replies.

Data field is there.

Another formula =count([Reference Number]) is working fine on the sheet. This one is represented in Total # of Responses.

Just that when distinct is added to the mix.. it somehow disappears. And outputs a '-'

m_woolf — Fri, 26 Oct 2018 19:08:49 GMT

Can you post a sample qvw that shows the problem?