Dollar expansion in Qlik Sense different to QlikView?

[alexis]

Hi,

I'm migrating an application from QlikView to Qlik Sense using the same QVDs, formulas etc.

One of my KPIs is not returning results in Qlik Sense. It is:

count({1<

[Shipment Year]=,

[Shipment Month]=,

[Shipment Quarter]=,

[numDeliveryDate]={'>=$(vStartOfCurrentYear)<=$(vMaxWorkDate)'},

[Destination_Shop] = {'0'},

[Destination_Region]={'UK'}>} BillNo)

Both the variables contain values, vStartOfCurrentYear has a value of 43101 and vMaxWorkDate has a value of 43368 as I expected.

I have many records that fall inside the range but my result comes back as zero.

My dollar expansion work in QlikView but fails (it seems) in Qlik Sense

Any ideas

Alexis

[alexis · Accepted solution]

Found the answer!!!!!

In Qlik Sense (June 2018 onward) the single quotes have been replaced with double quotes so the above should read:

count({1<

[Shipment Year]=,

[Shipment Month]=,

[Shipment Quarter]=,

[numDeliveryDate]={">=$(vStartOfCurrentYear)<=$(vMaxWorkDate)"},

[Destination_Shop] = {'0'},

[Destination_Region]={'UK'}>} BillNo)

Works fine now 🙂