topic Expression issue with conditions in QlikView

Expression issue with conditions

shyamcharan — Mon, 08 Dec 2014 20:02:06 GMT

Hi experts,

I have an expression as below with three conditions to get the latest written down value(WDV) of an asset.

I would need to get the WDV value for an asset that has 'Book' as the Category and the latest WDV determined by the Date ID.

Additionally I would need to filter out the WDV values based on Event Type and I would need only the 'Null' value event types.

=SUM({<DeprCategory={'Book'}, DPDateID = {"$(=max({1} DPDateID))"},[EventType]-={'*'}>}WDV)

But I could not get this working.

Attached is the QVW document that I attached for testing.

Can you please help me with this.

Thanks in advance.

Regards,

Shyam.

MK_QSL — Mon, 08 Dec 2014 20:21:22 GMT

=SUM({<DeprCategory = {'Book'},DPDateID = {'$(=Max(DPDateID))'},AssetID = {"=IsNull(EventType)"}>}WDV)

=SUM({<DeprCategory = {'Book'},DPDateID = {'$(=Max({1}DPDateID))'},AssetID = {"=IsNull(EventType)"}>}WDV)

shyamcharan — Fri, 12 Dec 2014 00:21:48 GMT

Thanks Manish.

The first one worked. Not sure why inclusion of {1} in the DPDateID condition did not work.

Thanks heaps.