Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

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
MVP
MVP

Re: Re: How to get dates not connected with dimmension

=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

9 Replies

Re: How to get dates not connected with dimmension

Like This,

Regards

ASHFAQ

andreyfcdk91
New Contributor III

Re: How to get dates not connected with dimmension

you concat dates which have any quantity.

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

Is it possible ?

Thank you!

Re: How to get dates not connected with dimmension

What o/p you are looking at?

Regards

ASHFAQ

andreyfcdk91
New Contributor III

Re: Re: How to get dates not connected with dimmension

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

Re: How to get dates not connected with dimmension

correct your expression as below

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

else

andreyfcdk91
New Contributor III

Re: How to get dates not connected with dimmension

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

Re: How to get dates not connected with dimmension

got it.. finding the correct approach

MVP
MVP

Re: Re: How to get dates not connected with dimmension

=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

andreyfcdk91
New Contributor III

Re: How to get dates not connected with dimmension

It's right)

Thx

Community Browser