topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys ,

Need help here, i am attaching the sample application here, please go through once , what i required is when i give date range it shud give the item count excluding the current selection.

Let say i have select one date 01-01-2015 and second date 01-04-2015 , than count of item code shud come 9, with in the date range count shud not display rest shud display.

pls suggest

Re: Logic Help

Peter_Cammaert — Fri, 25 Mar 2016 09:19:43 GMT

Try this expression in your text box:

=Count({$-<Date={">=$(=min(Lindate))<=$(=max(Lindate1))"}>} itemcode)

However, there will be some side effects you will need to take care of.

Peter

Re: Logic Help

Gysbert_Wassenaar — Fri, 25 Mar 2016 09:20:16 GMT

=count({1-<Date={'>$(=only(Lindate))<$(=only(Lindat1))'}>}itemcode)

Re: Logic Help

Peter_Cammaert — Fri, 25 Mar 2016 09:24:19 GMT

Note that it may look "ugly", but the expression will even work with the NULL dates you seem to have...

Re: Logic Help

abhaysingh — Fri, 25 Mar 2016 09:32:03 GMT

Hi,

Thanks for support

load * Inline /////////////////////////////////////Txn Table

[Date,itemcode,value,plant

01-01-2015,123,10,1001,

01-02-2015,124,20,1002

01-03-2015,125,30,1003,

01-04-2015,126,40,1004

01-05-2015,127,50,1005

01-06-2015,128,60,1001,

01-07-2015,129,70,1002

01-08-2015,130,80,1003

01-09-2015,130,90,1004

01-10-2015,129,100,1005,

01-11-2015,131,00,1005,];

right join

Tab2: /////////////////////////Master Table

load * Inline

[itemcode,plant

123,1001

124,1002

125,1003

126,1004

127,1005

128,1001,

129, 1002

130, 1003

130, 1004

129, 1005

111,1001

112,1002,

1123,1005,

131,1005];

In the Txn table if Item code value is 00 than it shud also come as Non Moving count, How to include it in expression?

Re: Logic Help

sunny_talwar — Fri, 25 Mar 2016 09:52:59 GMT

May be this:

NoConcatenate

Final:

LOAD * ,

Month(Date) as Month,

If(IsNull(value) or value = 00, 'NonMoving', value) as NonMoving,

If(IsNull(Date), 'NonMoving', Date) as DateNonMoving

Resident Tab1;

DROP Table Tab1;

Re: Logic Help

sunny_talwar — Fri, 25 Mar 2016 09:56:13 GMT

Actually my bad, I have no idea what you are looking for. The above might not be what you are looking for.