Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Concat dates with missing value

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;

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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.

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Please find the Attahced qvw for you reference

Highlighted
MVP
MVP

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

Highlighted
Creator
Creator

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

Highlighted
MVP
MVP

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.

View solution in original post