topic Re: Set analysis not work with the Server Migration in QlikView

Set analysis not work with the Server Migration

nuwanhwb87 — Wed, 09 Feb 2022 12:00:23 GMT

Hi,

We have done a Qlikview server migration with qlikview version update.

Now we have installed the below version.

Product Name : Qlikview Server May 2021 SR1

Version :12.60.20100.0

in my dashboard i have used below query .

=COUNT({$<ISSUE_DATE={">=$(=Today()-30)<=$(=Today())"}>Req_NO}

Above Query is not working in my current Version but works in the previous version

But when it Edit by removing the "=" sign near Today it works. like this =COUNT({$<ISSUE_DATE={">=$(Today()-30)<=$(Today())"}>Req_NO}

Please explain the reason

hic — Wed, 09 Feb 2022 16:20:14 GMT

Both the above expressions have incorrect syntax. They end with

... "}>Req_NO}

when they should end with

... "}>} Req_NO )

nuwanhwb87 — Thu, 10 Feb 2022 03:03:25 GMT

Hi,

Yes i have done a mistake when typing.

below with the Previous one

COUNT(DISTINCT{$<ISSUE_DATE={">=$(=Today()-30)<=$(=Today())"}>} REQ_NO)

This has not work in the new version but works in the Previous.

after edit it as below removing "=" sign near Today it works in current version .

COUNT(DISTINCT{$<ISSUE_DATE={">=$(Today()-30)<=$(Today())"}>} REQ_NO)