QlikView set analysis prior month not responding as QlikSense

[#1]

I have used an expression in QlikSense and works exactly the way I want to and provides the correct value, but when I try the same expression in QlikView it gives me a zero value.

The expression in question:

Sum({$<ReportDate={"$(=date(floor(monthstart(addmonths(Today(),-1))), 'MM/DD/YYYY'))"},[Deal - Status]={'Open'}, [DealExpected close - Year]={"2017"}>}if(match([Deal - Owner],'A','B','C')>0, [Weighted value]))

The expression seems to be breaking as a result of the ReportDate part of the set analysis.

[dberkesacn · Accepted solution]

It should work the same since the engine is the same. Do you have the same data model and your environment variables are also the same in both app ?

....

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6

....

[jmvilaplanap]

Hi,

If it works in Sense, it has no sense (badum chsssss!) that not works in View.

Check if all the model is the same, all the variables are the same, the values of the fields are in the same format.

I always convert the dates to numbers because the formats causes a lot of problems.

Regards and good luck!

[sunny_talwar]

May be you have different date format for ReportDate in QlikView vs Qlik Sense?

Sum({$<ReportDate={"$(=date(floor(monthstart(addmonths(Today(),-1))), 'MM/DD/YYYY'))"},[Deal - Status]={'Open'}, [DealExpected close - Year]={"2017"}>}if(match([Deal - Owner],'A','B','C')>0, [Weighted value]))

Change this to be in consistent with the ReportDate's format

[#5]

It worked when i made the environmental variables of QlikView exactly the same as QlikSense.

FYI this was how it was earlier:

Qlik Sense

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm TT';

SET TimestampFormat='MM/DD/YYYY hh:mm TT';

SET DateFormat='MM/DD/YYYY' ;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Qlik View

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';