Dual Function in Pivot Table

[ZoeM]

Hi Qlik community.

I have scoured the forums looking for information on how you can use the Dual Function in a expression in a Pivot table and couldnt ifnd anything.

Can any of you great experts help me with this?

I want to show the Item and Order date in one cell within a pivot table, please see attached.

And is there any way I can hide the 'Month' label? And just have the months showing as is.

Thanks so much!

Zoe-

[sunny_talwar]

Yes.. you can use comma or anything you would like....

=Concat(DISTINCT [Order Item], ', ')

&CHR(10)&

Only({$<[Date Type]={'VPP Dates'}>}[Date]))

[ZoeM]

Thanks Sunny! Works like a charm...