topic Help in QlikView

Help

panipat1990 — Tue, 18 Aug 2015 05:50:54 GMT

Hi,

Is It Possible To Have a Dynamic Title Of a Particular Sheet as per the maximum sale Which Is Changing EveryDay..My Title Display City Name Which Should Keep On Changing EveryDay and must Display Only The NameOf City Having Maximum Sales...Can anybody Please Share a Formula or Send A qvw With Example...

Re: Help

Tue, 18 Aug 2015 06:11:35 GMT

Store the Top1 value of City and total sales into a parameter, then in the sheet properties under title, call the parameter.

Re: Help

parthakk — Tue, 18 Aug 2015 06:24:13 GMT

In sheet properties under title write the following code

Concat(if(Aggr(Rank(sum(sales))<=1,city_name),city_name),',' & chr(13))

Thanks,

Partha Kulkarni

Re: Help

parthakk — Tue, 18 Aug 2015 06:25:49 GMT

Sorry instead of sum(sales) write max(sales)