topic Re: Re: How to get dates not connected with dimmension in QlikView https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663033#M474554 <HTML><HEAD></HEAD><BODY><P>I'm looking at your expression (Date), where you write:</P><P>=concat(Date,'-')</P><P></P><P>But it concat dates with quantity.</P><P>I want to concat such dates, which are on attached picture</P></BODY></HTML> Wed, 10 Sep 2014 06:11:10 GMT Anonymous 2014-09-10T06:11:10Z How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663029#M474550 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>In pivot table TASK i show quantity by dates and Spoints</P><P>My task is concate dates by Spoints without quantity.</P><P></P><P>Necessary result:</P><P><STRONG>Point1:</STRONG> 21-09-2013&nbsp; 22-09-2013</P><P><STRONG>Point2:</STRONG> 24-09-2013&nbsp; 25-09-2013 26-09-2013&nbsp; 27-09-2013</P></BODY></HTML> Wed, 10 Sep 2014 05:26:29 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663029#M474550 Anonymous 2014-09-10T05:26:29Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663030#M474551 <HTML><HEAD></HEAD><BODY><P>Like This,</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 10 Sep 2014 05:41:50 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663030#M474551 ashfaq_haseeb 2014-09-10T05:41:50Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663031#M474552 <HTML><HEAD></HEAD><BODY><P>you concat dates which have any quantity.</P><P>i want to concat dates with dashes ("-")</P><P></P><P>Is it possible ?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 10 Sep 2014 05:57:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663031#M474552 Anonymous 2014-09-10T05:57:17Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663032#M474553 <HTML><HEAD></HEAD><BODY><P>What o/p you are looking at?</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 10 Sep 2014 05:59:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663032#M474553 ashfaq_haseeb 2014-09-10T05:59:08Z Re: Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663033#M474554 <HTML><HEAD></HEAD><BODY><P>I'm looking at your expression (Date), where you write:</P><P>=concat(Date,'-')</P><P></P><P>But it concat dates with quantity.</P><P>I want to concat such dates, which are on attached picture</P></BODY></HTML> Wed, 10 Sep 2014 06:11:10 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663033#M474554 Anonymous 2014-09-10T06:11:10Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663034#M474555 <HTML><HEAD></HEAD><BODY><P>correct your expression as below</P><P></P><P>=concat({&lt;Date={"=sum(Quantity)&gt;0"}&gt;}DISTINCT Date,'-')</P><P></P><P>else</P><P><SPAN class="j-post-author"><STRONG><A href="https://community.qlik.com/people/ashfaq_haseeb">ashfaq_haseeb</A>&nbsp;&nbsp; </STRONG>&nbsp; also provide a good solution<BR /></SPAN></P></BODY></HTML> Wed, 10 Sep 2014 06:48:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663034#M474555 2014-09-10T06:48:04Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663035#M474556 <HTML><HEAD></HEAD><BODY><P>i don't need to get dates where quantity&gt;0</P><P>I want to get dates which haven't quantity. (as i understand, it's missing values)</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Necessary result:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Point1:</STRONG> 21-09-2013&nbsp; 22-09-2013</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">Point2:</STRONG> 24-09-2013&nbsp; 25-09-2013 26-09-2013&nbsp; 27-09-2013</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you!</P></BODY></HTML> Wed, 10 Sep 2014 06:54:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663035#M474556 Anonymous 2014-09-10T06:54:00Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663036#M474557 <HTML><HEAD></HEAD><BODY><P>got it.. finding the correct approach <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 10 Sep 2014 06:56:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663036#M474557 2014-09-10T06:56:48Z Re: Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663037#M474558 <HTML><HEAD></HEAD><BODY><P>=<SPAN style="color: #0000ff; font-size: 10pt;">concat</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="font-size: 10pt;">{1&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">e</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">)&gt;}</SPAN><SPAN style="color: #800000; font-size: 10pt;">Date, ','</SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P><SPAN style="font-size: 10pt;">Limitation: You have to select a Spoint value to see the output, because set analysis doesn't evaluate row-wise.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Alternatives:</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="text-decoration: underline;">Script:</SPAN> Create a seperate field to see these unassociated dates</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="text-decoration: underline;">Front-end: </SPAN>Use synthetic dimension and use =Pick(Match(...&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // a relatively complex solution</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">PFA</SPAN></P></BODY></HTML> Wed, 10 Sep 2014 07:21:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663037#M474558 tresB 2014-09-10T07:21:24Z Re: How to get dates not connected with dimmension https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663038#M474559 <HTML><HEAD></HEAD><BODY><P>It's right)</P><P>Thx</P></BODY></HTML> Wed, 10 Sep 2014 08:29:36 GMT https://community.qlik.com/t5/QlikView/How-to-get-dates-not-connected-with-dimmension/m-p/663038#M474559 Anonymous 2014-09-10T08:29:36Z