Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 🙂
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 🙂