topic Re: Value before Min Value in QlikView

Value before Min Value

Anonymous — Mon, 07 Mar 2016 07:30:32 GMT

I have a list box with values in text , I need to display the value before minimum value , by usng minstring(column) I get the minimum value sorted alphabetically how do I get the value before that?

Thanks

Re: Value before Min Value

avinashelite — Mon, 07 Mar 2016 07:35:06 GMT

try like this

min(column, 2) this will give the 2 min value of your column

Re: Value before Min Value

Anonymous — Mon, 07 Mar 2016 07:38:23 GMT

it is a string so I have to use minstring right? with min I am not getting values

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 07:38:32 GMT

Hi,

You can try this.

=MinString({<Name -= {"$(=Minstring(Name))"}>}Name)

Regards,

Kaushik Solanki

Re: Value before Min Value

Anonymous — Mon, 07 Mar 2016 07:46:20 GMT

This gives me a value but not picking the 1 value before minstring ..but 4 values before the minstring value

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 07:55:45 GMT

Hi,

Can you share sample values. Also tell us what value you want as output.

Regards,

Kaushik Solanki

Re: Value before Min Value

avinashelite — Mon, 07 Mar 2016 07:58:10 GMT

please share the sample data ??

Re: Value before Min Value

Digvijay_Singh — Mon, 07 Mar 2016 07:58:46 GMT

confusing, as nothing can be before minstring, I thought you wanted next minimum value which can be generated using Kaushik.solanki expression. Please elaborate further the req.

Re: Value before Min Value

Anonymous — Mon, 07 Mar 2016 08:14:41 GMT

With Kaushik's expression I get the value underlined in Red , I am looking for Yellow highlighted value , I guess the values being case sensitive is causing issue

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 08:23:30 GMT

Hi,

This is because the way minimum string is found is it gets converted into ASCII values and then as per the ASCII values the function gives you the minimum String.

If you look that way then the minimum string is AgentServiceCenter and then within that the Minimum will be AgentServiceCenter:M...... Because in ASCII table Capital latter have minimum ASCII values.

Regards,

Kaushik Solanki

Re: Value before Min Value

Anonymous — Mon, 07 Mar 2016 08:26:20 GMT

oh ok .. thank you for the explanation , so there is no way that we could get the value I am looking for ?

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 08:28:53 GMT

It would be helpful if you share sample application with this data.

Regards,

Kaushik Solanki

Re: Value before Min Value

tamilarasu — Mon, 07 Mar 2016 08:32:52 GMT

Kausik,

In that case, can we use like below.??

=MinString({<F1-={"$(=Minstring(Lower(F1)))"}>} Lower(F1))

But field values will be converted to lower case.

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 08:34:28 GMT

Hi,

Yes if you change the string into Lower Case it should work.

Regards,

Kaushik Solanki

Re: Value before Min Value

Anonymous — Mon, 07 Mar 2016 08:34:56 GMT

Sure , Attached.

Re: Value before Min Value

kaushiknsolanki — Mon, 07 Mar 2016 08:40:33 GMT

Hi,

The solution given by Tamil will work

=MinString({<[Group-Function] -= {"$(=Minstring([Group-Function]))"}>}lower([Group-Function]))

Regards,

Kaushik Solanki

Re: Value before Min Value

Anonymous — Tue, 08 Mar 2016 20:44:07 GMT

Yes this works Thank you!, but I also have to display this value in the chart , so basically what I am trying to do is select Min value from group-function when the app open , so I have set this value in Open Triggers , I have the title of a chart to display the selected GroupFunction value with the below expression, but this does not display when I open the App , it only displays when I manually select the same value from the filter again.

=IF(GetFieldSelections([Group-Function])=[Group-Function],[Group-Function])

Re: Value before Min Value

kaushiknsolanki — Wed, 09 Mar 2016 07:31:46 GMT

Kindly share the QVW file.

Regards,

Kaushik Solanki