Skip to main content

App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
alexis
Partner - Creator III
Partner - Creator III

Dollar expansion in Qlik Sense different to QlikView?

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

1 Solution

Accepted Solutions
alexis
Partner - Creator III
Partner - Creator III
Author

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 🙂

View solution in original post

1 Reply
alexis
Partner - Creator III
Partner - Creator III
Author

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 🙂