Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
Please find the Attahced qvw for you reference
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().
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
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.