topic Get only one value from the table in QlikView

Get only one value from the table

Anonymous — Tue, 31 Jan 2012 06:50:58 GMT

Hi.

Is there any way where I can get only one perticular value from a table.

For Example in the above table I want to get the value where Month is May. I tried using if but it works if only i select the month. can anyone tell me how to use set analysis or any method to get this done as I wont be doing any selection in this table. I only need the value for a perticular month only.

Get only one value from the table

Anonymous — Tue, 31 Jan 2012 06:54:49 GMT

Or if possible can I get the position of 'MAY' in the record. Like that I can get the corresponding value for that month.

Get only one value from the table

perumal_41 — Tue, 31 Jan 2012 07:01:28 GMT

Hi,

Try this Expression Sum({<Month={'May'}>} Field).

This Expression helpful for U

Regards ,

Perumal A

Get only one value from the table

lalitinmbd — Tue, 31 Jan 2012 07:07:58 GMT

You ca use any of the following

1.Sum(if(Month='May',Value))

2.Sum({<Month={'May'}>} Value)

Hope this help you Out.

Get only one value from the table

Anonymous — Tue, 31 Jan 2012 07:13:47 GMT

Thank you, but I am sorry that I missed one point. I cant use sum as my field contains Alpha Numeric values, like below.

Get only one value from the table

CELAMBARASAN — Tue, 31 Jan 2012 07:15:49 GMT

Hi,

You can get the position and the value by using this function

FieldValue('Value',FieldIndex( 'Month', 'May' ))

This may help you

Celambarasan

Get only one value from the table

CELAMBARASAN — Tue, 31 Jan 2012 07:17:34 GMT

Or you can use

Concat({<Month={'May'}>} Value,',')

MinString({<Month={'May'}>} Value)

Celambarasan

Get only one value from the table

perumal_41 — Tue, 31 Jan 2012 07:26:50 GMT

Hi,

Try this Expression only({<Month={'May'}>} Field).

This Expression helpful for U

Regards ,

Perumal A