Table with Yes or No based on Date

[karan_kn]

Please help me to create table with Yes or No. Yes and highlighted with No

T1:

LOAD * INLINE [

    ID, Date

    1, 2015

    1, 2016

    1, 2018

    2, 2017

    2, 2018

    3, 2015

    3, 2016

    3, 2017

    3, 2018

    4, 2016

];

[Frank_Hartmann · Accepted solution]

Pivot Table:

Dimension1 = ID

Dimension2 = Date

Expression = if(concat(Date,',',Date)<>'','Yes','No')

Then drag Date Dimension to the upper right until you see a blue horizontal line

Output:

[m_woolf]

See the attached qvw.

[MarcoWedel]

another possible pivot table expression:

If(Count(ID),'Yes','No')

hope this helps

regards

Marco

[vishsaggi]

Another solution may be like Add pivot with

Dim:

Id

Date

Expr:

= If(Count(ID) = 1, 'Yes', 'No')

[vishsaggi]

Haha. Almost sneaked your thought process. 😉

[MarcoWedel]

indeed