Concat dates with missing value

[Anonymous]

Good day!

In attached file i have pivot table "Task".

My task is to concat dates with missing value (quantity)

Is there anyway to solve it ?

Necessary result:

Spoint1:21-09-2013;  22-09-2013

Spoint2:25-09-2013;  26-09-2013;   27-09-2013;

[alkesh_sharma]

Please find the Attahced qvw for you reference

[tresesco]

Set analysis component E() gives the values which are excluded in scope. If you select a Spoint and try expression: =Concat( {<Spoint,Date=e(Date)>} DISTINCT Date, '; ')          in a textbox, you would see the desired result. However, this would not work in a chart. If you wish to have that in a chart, you probably have to take a bit more complex way; using synthetic dimension, i.e: valuelist()/valueloop().

[Anonymous]

Thank you for your answer.

Could you write me please about valuelist()/valueloop() (in simple example please), because i have never used them

Best regards

[tresesco · Accepted solution]

Check the attached sample; a simple one; not very dynamic. To make it dynamic you have to use Pick(Match... along with concatenated formula string.