topic max for each base station in QlikView

max for each base station

SunilChauhan — Fri, 15 Apr 2011 06:56:11 GMT

hello all ,

i am attaching excel sheet which contain a pivot table screenshot.

I want to create a listbox to select max DL value for each base station .and hour related to thosemax values.

Fast reply will be appreciated

thanks much

Sunil

max for each base station

tresB — Fri, 15 Apr 2011 07:25:41 GMT

Hi Sunil,

Use AGGR() function to group the data by base station and then use MAX() function to get the max DL values, and again if you want the corresponding hours, you might use FIELDVALUE() function (provided your DL values are not calculated amount, i.e they are coming directly from the loaded data).

Regards, tresesco

max for each base station

SunilChauhan — Fri, 15 Apr 2011 07:34:31 GMT

but i want a listbox where i can select and result will appear in pivot table.

thanks

Sunil

max for each base station

tresB — Fri, 15 Apr 2011 07:39:46 GMT

in list box, go to expression option and write the expression to calculate the base station wise max DL values. once they are displayed, you can select from there and the corresponding data would be displayed in pivot table.

Regards, tresesco

max for each base station

SunilChauhan — Fri, 15 Apr 2011 07:48:25 GMT

i have tried that also .thations goving one max for all station.

but i want one for each base station.

bs 10.0.0.12 - Max dl value

bs 10.0.0.13 - Max dl value

bs 10.0.0.14 - Max dl value

bs 10.0.0.15 - Max dl value

on all on single selection

thanks

sunil

max for each base station

tresB — Fri, 15 Apr 2011 07:54:17 GMT

if you use AGGR() function properly with MAX() function, it should give your expected result.

max for each base station

SunilChauhan — Fri, 15 Apr 2011 10:44:36 GMT

hello i am attaching qvw file please look into and suggest me

thanks

sunil

max for each base station

sushil353 — Fri, 15 Apr 2011 11:01:19 GMT

Hi check this out

max(

expression [, rank])

Returns the maximum numeric value of

expression encountered over a number of records as defined by a group by clause. Rank defaults to 1 which correspond to the highest value.

max for each base station

sushil353 — Fri, 15 Apr 2011 11:02:52 GMT

Hi check this out

max(

Returns the maximum numeric value of expression encountered over a number of records as defined by a group by clause. Rank defaults to 1 which correspond to the highest value.

expression [, rank])