Solved: calculated dimension - Page 2 - Qlik Community

Report Inappropriate Content · ‎2016-10-06

Hi Experts,

I have a table which has fields Product no, Delivery details.

below are some sample field values.

I need to populate this in a pivot table, but i want to display one line per Product.

For ex. if a product has two lines Delivered at... & Not Delivered, then i want to display 'Delivered at..'

if a product has one line, display as it is.

The result should be,

i dont want to do this in script. i want this in table.

Please somebody help me

effinty2112 · ‎2016-10-06

You could try:

Set a variable to keep things tidy:

vDelivered = if(WildMatch([Delivery Details],'*Delivered at*'),1,0)

Then use this expression:

if(sum($(vDelivered)) = 0, 'Not delivered', concat(if($(vDelivered) = 1,[Delivery Details])))

giving this table:

Regards

Andrew

Report Inappropriate Content · ‎2016-10-10

Thanks to all

calculated dimension