Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-
You don't need dual function for this... you can try this
Item & ' ' & [Order Date]
You don't need dual function for this... you can try this
Item & ' ' & [Order Date]
Amazing!
That is exactly what I was hoping for.
As always, thanks Sunny!
So Mexico and Uruguay bought multiple items on the same date. How can I show these items in the same cell and just one date?
You can use Concat
Concat(DISTINCT Item & ' ' & [Order Date])
The date is duplicated for each Order Item. Is it possible to have only one date? Since they are the same...
Try this then
Concat(DISTINCT Item) & ' ' & [Order Date]
For the data set I am working in, I am using Set Analysis where the date field is coming into the QVW via a Date Key. So I have to distinguish the date field as below:
Only({$<[Date Type]={'VPP Dates'}>}[Date])
When I write my expression to concatenate the order Item and Purchase date I am getting an error:
=Concat(DISTINCT 9Order Item]&CHR(10)&
Only({$<[Date Type]={'VPP Dates'}>}[Date]))
What could be the issue?
what is 9Order Item]? Typo? Also, a missing parenthesis... try this
=Concat(DISTINCT [Order Item])
&CHR(10)&
Only({$<[Date Type]={'VPP Dates'}>}[Date])
I saw what it was...I forgot a parenthesis.
Your formula works, however there is no space between the Items:
ScrapersTrophies
Any way to separate?