topic Re: Table with Yes or No based on Date in QlikView

Table with Yes or No based on Date

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 11 Sep 2018 19:15:11 GMT

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 — Tue, 11 Sep 2018 19:15:19 GMT

See the attached qvw.

MarcoWedel — Tue, 11 Sep 2018 20:51:32 GMT

another possible pivot table expression:

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

hope this helps

regards

Marco

vishsaggi — Tue, 11 Sep 2018 20:52:40 GMT

Another solution may be like Add pivot with

Dim:

Date

Expr:

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

vishsaggi — Tue, 11 Sep 2018 20:53:31 GMT

Haha. Almost sneaked your thought process. 😉

MarcoWedel — Tue, 11 Sep 2018 20:54:56 GMT

indeed