Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
decodesolucoes
New Contributor

QVW to QVF conversion not working properly

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.

6 Replies
Partner
Partner

Re: QVW to QVF conversion not working properly

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.

 

Blog: WhereClause   Twitter: @treysmithdev
Highlighted
decodesolucoes
New Contributor

Re: QVW to QVF conversion not working properly

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])

 

MVP & Luminary
MVP & Luminary

Re: QVW to QVF conversion not working properly

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

Partner
Partner

Re: QVW to QVF conversion not working properly

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.

Blog: WhereClause   Twitter: @treysmithdev
decodesolucoes
New Contributor

Re: QVW to QVF conversion not working properly

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?

MVP & Luminary
MVP & Luminary

Re: QVW to QVF conversion not working properly

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

-Rob