Solved: How to get dates not connected with dimmension - Qlik Community

Anonymous · ‎2014-09-10

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

tresesco · ‎2014-09-10

=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

ashfaq_haseeb · ‎2014-09-10

Like This,

Regards

ASHFAQ

Anonymous · ‎2014-09-10

you concat dates which have any quantity.

i want to concat dates with dashes ("-")

Is it possible ?

Thank you!

ashfaq_haseeb · ‎2014-09-10

What o/p you are looking at?

Regards

ASHFAQ

Anonymous · ‎2014-09-10

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

Report Inappropriate Content · ‎2014-09-10

correct your expression as below

=concat({<Date={"=sum(Quantity)>0"}>}DISTINCT Date,'-')

else

ashfaq_haseeb also provide a good solution

Anonymous · ‎2014-09-10

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)