Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rahulsud007
Contributor

Is there any issue with the E() and P() in qliksense

Hi All, I would like to use my qlikview expressions in qlik sense.

I am using the following expression in qlikview and qliksense.

Sum({<Fin_Year_Set= {'$(=vmaxyear-1)'}, phoneno= e({<sales={'>0'}, Fin_Year_Set = {'$(= vmaxyear)'}>}) >} sales)

That is I would like to get previous year sales, but I want to exclude those phone no who have purchased in the current year.

The expression is perfectly working in qlikview, but not in qliksense with the same data set. In all expressions, everything is working fine apart from p() and e().

Please help.

Regards

Rahul

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Is there any issue with the E() and P() in qliksense

They should work exactly the same. Except for one thing...

The recent versions of Qlik Sense and of QlikView are enforcing much more strict and correct use of quotation characters when it comes to literal strings versus search strings in Set Expressions.

In a search string like your e('>0') you should and must use e(">0"). Older versions of both QV and QS didn't mind this and did the search anyway - even if you use the single quotation marks. This is not the case any more.

3 Replies
MVP
MVP

Re: Is there any issue with the E() and P() in qliksense

They should work exactly the same. Except for one thing...

The recent versions of Qlik Sense and of QlikView are enforcing much more strict and correct use of quotation characters when it comes to literal strings versus search strings in Set Expressions.

In a search string like your e('>0') you should and must use e(">0"). Older versions of both QV and QS didn't mind this and did the search anyway - even if you use the single quotation marks. This is not the case any more.

rahulsud007
Contributor

Re: Is there any issue with the E() and P() in qliksense

Thanks Peter, that is the reason. I needed to add  e(">0") instead  of e('>0'). thanks a lot.

MVP
MVP

Re: Is there any issue with the E() and P() in qliksense

You're welcome - happy to help

Community Browser