topic Re: How to display in the listbox along with min and max values? in QlikView

How to display in the listbox along with min and max values?

jagannalla — Sun, 31 Jul 2011 12:30:29 GMT

Hi,

In my qvd file i've different number of fields. I want to divide this fields into few groups and display in this listbox along with there min & max value in the expression.

First, the fields in qvd say A1,A2,A3,B1,B2,B3,C1,C2,C3....etc. For each field i'm able to catch min and max values. But how can i show in one listbox all A groups along with min and max values.

For Eg:

I want to see in the listbox like this:

GroupA Min Max

A1 3 5

A2 2 4

A3 5 10

How to display in the listbox along with min and max values?

jagannalla — Sun, 31 Jul 2011 13:23:38 GMT

To achive this i had taken seperate excel with columns GroupA, Min, Max.

so that i can see as above post structure in the listbox. But when qvd file data is updated the field values data will be changed. I'll face the problem at dat time so, i want to update this excel file also.

How can i overcome this. Whether it is possible to do it.

Can anyone help me on this problem otherwise give me few ideas in different format to achive this.

- Why i'm trying this b'coz the user can able to choose his own fields from different number of fields in listbox. At the end he can see only those fields in output. I did all this things but i got struct when the qvd file is updated.

How to display in the listbox along with min and max values?

nagaiank — Sun, 31 Jul 2011 14:57:14 GMT

Did you try listbox with expressions?

Re: How to display in the listbox along with min and max values?

Mon, 01 Aug 2011 03:10:41 GMT

Hi,

You can try creating a table box with these 3 columns Group, Min and Max so user can see the groups and their min and maxes next to them.

Or try attaching the sample data.

Cheers.

How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 05:28:45 GMT

Krishnamoorthy / BlacRock S,

- Krishnamoorthy.. i tried with listbox only. But in the listbox we can't display all fields at a time. To achive this we need to take seperate field(i.e GroupA) and data for this field is fields of qvd file(i.e A1,A2,A3..). And one more point is we need to display Min & Max values of A1,A2,A3.. with field Min & Max then only we can see the data in the listbox.

- BlackRock S.... In tablebox we can provide checkboxes, it is possible with listbox only. The user needs to select this own fields only. After selecting in the listbox i'm storing all selections in one variable.

How to display in the listbox along with min and max values?

kaushiknsolanki — Mon, 01 Aug 2011 06:38:02 GMT

Hi,

According to my understanding you can try this.

Create a list box, with expression.( in properties ->General Tab-> Fields -> Expression) Type expression as

=if(wildmatch(FIeld1,'A*'),Value)

For Group A

and in expression tab.

Create two expression as MIn(Value) and Max(Value)

Regards,

Kaushik Solanki

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 06:57:10 GMT

I didn't get what your are saying. What is the Value here.

- I'm attaching sample qvw file. Can you please see it once.

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 07:47:05 GMT

kaushik,

Did you understood what i said. Can you please respond to my post.

Re: How to display in the listbox along with min and max values?

Mon, 01 Aug 2011 07:57:00 GMT

Hi,

you need to change the way data is loading, please see if the attached can give you some direction.

Cheers.

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 08:24:41 GMT

BlackRock S,

It's good actually. But how can i create Data,Val fields in qvd file. I'm attaching sample qvd file . Can you do it on that qvd file. B'coz you have taken excel sheet and created Data,Val fields manually i think. But how to get all those thinks along with single qvd file.

Please sorry to ask again.

Re: How to display in the listbox along with min and max values?

Mon, 01 Aug 2011 08:30:11 GMT

Hi,

Its very simple, first load the QVD you have as you loaded earlier. Then create a straight table in Qlikview itself then export to excel.

Thats what i did, i just exported the data from your earlier example attached and i saved in excel. But while loading i loaded as cross table in qlikview script loading.

Cheers.

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 08:50:45 GMT

ya wt you said is correct. I understood the procedure but when qvd file is updated again i'll face the problem. Every time the min and max value will be changed based on the updation done to qvd file. Now, you have manually creating data in excel. Thats what i said in my first post.

Re: How to display in the listbox along with min and max values?

Mon, 01 Aug 2011 09:34:02 GMT

Hi,

Can you attach your QVD.

Cheers.

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 09:45:14 GMT

Ok this enclosed file is qvd.

Re: How to display in the listbox along with min and max values?

rahulgupta — Mon, 01 Aug 2011 09:46:51 GMT

Hey Hi,

Kindly find the attached file.

Hope this will surely solves your problem.

Regards

Re: How to display in the listbox along with min and max values?

Mon, 01 Aug 2011 09:59:08 GMT

Hi,

Please see the attached to load the data based on your QVD.

Cheers.

Re: How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 12:14:38 GMT

Thanks a lot Rahul, Actually i tried previously as you did. But, i'm not able to make group.

How to display in the listbox along with min and max values?

jagannalla — Mon, 01 Aug 2011 12:40:37 GMT

BlockRock S,

Your logic is good. But the think is we need to create another more two fields manually(i.e Data,Val).

Re: How to display in the listbox along with min and max values?

Tue, 02 Aug 2011 02:56:28 GMT

Hi,

I dont think you are pretty new to Qlikview.

In my prvious post, i havent created any new data manually, i loaded the QVD you posted using crosstable option in Qlikview and named the fields Data and val while loading.

You can try that script to reload a new QVD file that you have, even you can add new data to that QVD and test the reload?

Feel free to let me know if you still cant get it how it is working.

Cheers.

How to display in the listbox along with min and max values?

jagannalla — Tue, 02 Aug 2011 05:27:25 GMT

BlackRock S,

I'm extremly sorry It's also correct.