Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everbody,
I'm pretty new to Qlik and I'm trying to filter the expression below by a field called "Plnt".
I will need this expression only for Plnt = 3900 but I just can't get it.
((sum(if([Data Ext.]=Today(),([LDM (Lung)]*[Order Quantity])))) / (max(aggr(Sum([LDM (Lung)]*[Order Quantity]),[Data Ext.]))))
Could you please help me?
Thanks a lot in advance!!
Nicolas
You would need something like this.
...{<[PInt]={'3100'}>}..
You may find the link below valuable.
You would need something like this.
...{<[PInt]={'3100'}>}..
You may find the link below valuable.
Thanks for you reply!
How can I construct the whole expression?
Where do I have to put this {<[PInt]={'3100'}>} ?
((sum(if([Data Ext.]=Today(),([LDM (Lung)]*[Order Quantity])))) / (max(aggr(Sum([LDM (Lung)]*[Order Quantity]),[Data Ext.]))))