topic QVW to QVF conversion not working properly in App Development

QVW to QVF conversion not working properly

decodesolucoes — Tue, 17 Sep 2019 17:41:59 GMT

Good afternoon,

I've converted a project on Qlik Sense Converter, but all my set analysis are returning value 0. They're working normally on Qlik View.

Is there any difference between Qlik View and Qlik Sense set analysis?

Thanks.

Re: QVW to QVF conversion not working properly

treysmithdev — Tue, 17 Sep 2019 22:47:21 GMT

Do you use single quotes for advanced search?

Example: (Specifically the '>0' part)

Count({<Qty = {'>0'}>} ProductID)

If so, those now require double quotes:

Count({<Qty = {">0"}>} ProductID)

Previously single quotes still worked, however it was known as a bug. As of Qlik Sense November 2017 and I think QlikView 12.20, the bug was fixed and many set analysis expressions stopped working, unless they were recognized as an older version. This would not be the case for a conversion.

Read HIC Blog Post for more info on it.

Re: QVW to QVF conversion not working properly

decodesolucoes — Wed, 18 Sep 2019 00:39:53 GMT

Good night,

Here's one of the expressions that is returnig value 0

= (COUNT ({<HireDate={">=$(StartDate)<=$(EndDate)"}>} DISTINCT ID))

Where:

StartDate =Max(TOTAL [DATA_SYSTEM])

EndDate =MIN(TOTAL [DATA_SYSTEM])

Re: QVW to QVF conversion not working properly

rwunderlich — Wed, 18 Sep 2019 01:56:32 GMT

There is no general design difference between Set Analysis in QV and QS. Except, as previously mentioned, where bugs have been fixed or introduced. This is more of a release rather than a product issue as the products share common engine code. For example what @treysmithdev mentioned as closing the loophole for single quotes in an advanced search. There was also a bug for some period requiring double quotes around dual values. So converting from a QlikView (possibly older engine version) QlikView to QlikSense (possibly newer engine version) you may have encountered one of these changes.

However, looking at the details of your reported problem I don't see any bugs or behavior changes I'm aware of. Instead I would validate that the conversion was complete in regards to variables etc.

Qlik Sense has a wonderful expression preview in the Expression Editor. Open the expression you reported as problematic and confirm in the preview at the bottom that the variables are returning expected values and the the syntax checks out OK.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: QVW to QVF conversion not working properly

treysmithdev — Wed, 18 Sep 2019 01:59:17 GMT

You can try:

= (COUNT ({<HireDate={">=$(=StartDate)<=$(=EndDate)"}>} DISTINCT ID))

In case you haven't done so already, make sure your variables are populated in your Sense conversion.

Re: QVW to QVF conversion not working properly

decodesolucoes — Thu, 19 Sep 2019 00:09:50 GMT

Good night,

When I use the expression below, I got return.

=(Count({$<HireDate={$(StartDate)}>}DISTINCT ID)

But when I use this expression (need a date range), I have no results.

=(Count({<HireDate={">=$(=StartDate)<=$(EndDate)"}>} DISTINCT ID))

HireDate, StartData and EndDate are the same type of data.

What might be happening?

Re: QVW to QVF conversion not working properly

rwunderlich — Fri, 20 Sep 2019 04:41:20 GMT

What does the expression look like in the QS expression preview after the variable substitutions are done?

-Rob