Discussion Board for collaboration related to Creating Analytics for QlikView.
In pivot table TASK i show quantity by dates and Spoints
My task is concate dates by Spoints without quantity.
Point1: 21-09-2013 22-09-2013
Point2: 24-09-2013 25-09-2013 26-09-2013 27-09-2013
Go to Solution.
Limitation: You have to select a Spoint value to see the output, because set analysis doesn't evaluate row-wise.
Script: Create a seperate field to see these unassociated dates
Front-end: Use synthetic dimension and use =Pick(Match(... // a relatively complex solution
you concat dates which have any quantity.
i want to concat dates with dashes ("-")
Is it possible ?
What o/p you are looking at?
I'm looking at your expression (Date), where you write:
But it concat dates with quantity.
I want to concat such dates, which are on attached picture
correct your expression as below
ashfaq_haseeb also provide a good solution
i don't need to get dates where quantity>0
I want to get dates which haven't quantity. (as i understand, it's missing values)
got it.. finding the correct approach