Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tan_chungkam
Creator
Creator

Pivot Table show missing value

Hi All,

Is there anyway to show the Fruit on 01/01/2018 and 02/01/2018?

As John has different fruit on same date, hence the pivot table won't show the value.

I would like to see 'Apple & Banana' on 01/01/2018 and 'Banana & Orange' on 02/01/2018.

Is there anyway to do it?

Please find attached my qvf and excel files.

and also my screenshot for your references.my desire outcomemy desire outcome

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Use this expression

Concat(DISTINCT Fruit, '/')

View solution in original post

1 Reply
sunny_talwar

Use this expression

Concat(DISTINCT Fruit, '/')