Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get dates not connected with dimmension

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

=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

View solution in original post

9 Replies
ashfaq_haseeb
Champion III
Champion III

Like This,

Regards

ASHFAQ

Anonymous
Not applicable
Author

you concat dates which have any quantity.

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

Is it possible ?

Thank you!

ashfaq_haseeb
Champion III
Champion III

What o/p you are looking at?

Regards

ASHFAQ

Anonymous
Not applicable
Author

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

Not applicable
Author

correct your expression as below

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

else

Anonymous
Not applicable
Author

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!

Not applicable
Author

got it.. finding the correct approach

tresesco
MVP
MVP

=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

Anonymous
Not applicable
Author

It's right)

Thx