Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day!
In pivot table TASK i show quantity by dates and Spoints
My task is concate dates by Spoints without quantity.
Necessary result:
Point1: 21-09-2013 22-09-2013
Point2: 24-09-2013 25-09-2013 26-09-2013 27-09-2013
=concat({1<Date=e(Date)>}Date, ',')
Limitation: You have to select a Spoint value to see the output, because set analysis doesn't evaluate row-wise.
Alternatives:
Script: Create a seperate field to see these unassociated dates
Front-end: Use synthetic dimension and use =Pick(Match(... // a relatively complex solution
PFA
Like This,
Regards
ASHFAQ
you concat dates which have any quantity.
i want to concat dates with dashes ("-")
Is it possible ?
Thank you!
What o/p you are looking at?
Regards
ASHFAQ
I'm looking at your expression (Date), where you write:
=concat(Date,'-')
But it concat dates with quantity.
I want to concat such dates, which are on attached picture
correct your expression as below
=concat({<Date={"=sum(Quantity)>0"}>}DISTINCT Date,'-')
else
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)
Necessary result:
Point1: 21-09-2013 22-09-2013
Point2: 24-09-2013 25-09-2013 26-09-2013 27-09-2013
Thank you!
got it.. finding the correct approach
=concat({1<Date=e(Date)>}Date, ',')
Limitation: You have to select a Spoint value to see the output, because set analysis doesn't evaluate row-wise.
Alternatives:
Script: Create a seperate field to see these unassociated dates
Front-end: Use synthetic dimension and use =Pick(Match(... // a relatively complex solution
PFA
It's right)
Thx