topic Re: Concat dates with missing value in QlikView

Concat dates with missing value

Anonymous — Wed, 31 Dec 2014 08:30:33 GMT

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;

Re: Concat dates with missing value

alkesh_sharma — Wed, 31 Dec 2014 08:55:04 GMT

Please find the Attahced qvw for you reference

Re: Concat dates with missing value

tresB — Wed, 31 Dec 2014 09:06:23 GMT

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().

Re: Concat dates with missing value

Anonymous — Wed, 31 Dec 2014 09:20:46 GMT

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

Re: Concat dates with missing value

tresB — Wed, 31 Dec 2014 11:57:36 GMT

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.