topic Re: Min date for current selection in QlikView

Min date for current selection

dseelam — Thu, 16 Feb 2017 21:55:21 GMT

Hello all,

I have 3 columns Item, INVB AND Date, I need to create a expression saying that if INVB<0 give me min date for current selection for particular item

Can some one help me putting these in to set analysis

thanks,

Re: Min date for current selection

vishsaggi — Thu, 16 Feb 2017 22:02:52 GMT

May be this?

= Min({< INVB = {'<0'} >} Date)

Re: Min date for current selection

shraddha_g — Fri, 17 Feb 2017 05:50:29 GMT

Min({$<INVB={"<0"}>}Date)

Re: Min date for current selection

Anonymous — Fri, 17 Feb 2017 05:58:26 GMT

Understanding the query, we need Min(Date) where INVB<0. So using the set Analysis, INVB is equal to(=) the set of values which satisfy condition (<0 ). put Where clause in the braces.like {<INVB={" < 0"} >}. Makes it

Min({<INVB= {"< 0"} >}Date).

The expression within the " " is evaluated and will get the required result.

You can use this expression against the item as the dimension in a table and can get the value of each item against it.

Hope it helps.

Re: Min date for current selection

dseelam — Thu, 23 Feb 2017 14:20:21 GMT

below error has been occurred when trying to implement above solution mentiones

Re: Min date for current selection

vishsaggi — Thu, 23 Feb 2017 14:30:23 GMT

What is the error you are getting? Even though you are getting those squiggly line did you press ok and checked? Is your INVB a calculated expression?

Re: Min date for current selection

vishsaggi — Thu, 23 Feb 2017 14:36:35 GMT

Seems you have duplicate thread here?

Min Date

Re: Min date for current selection

avinashelite — Thu, 23 Feb 2017 14:38:33 GMT

Try like this

if(INVB<0,min(WKDT))

You cannot direct use the expression name in the set analysis

Re: Min date for current selection

dseelam — Thu, 23 Feb 2017 14:40:05 GMT

Yes Nag, I did attached a working test file attached in this thread can you check it, I don't know hoe to attach same files in this reply

Re: Min date for current selection

vishsaggi — Thu, 23 Feb 2017 14:41:31 GMT

Ok, did you try what avinash suggested? And also can you tell us what is your expected output should be for MinDate?