topic Re: I need Brand Name. in QlikView

I need Brand Name.

Tue, 10 Dec 2013 06:06:24 GMT

max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand))

I am using the above expression and getting the maximum sentiment % of a Particular Brand but I want to find the name of the Brand which has maximum sentiment %age.

So ,Please Help me on this.

Thanks in Advance.

Re: I need Brand Name.

Tue, 10 Dec 2013 06:16:01 GMT

Hi anand

can you attach some sample

Re: I need Brand Name.

Anonymous — Tue, 10 Dec 2013 06:16:53 GMT

If you have brand as your dimension, what happens? Do you not get the correct sentiment percentage mapped to the brand name.

Re: I need Brand Name.

Tue, 10 Dec 2013 06:22:30 GMT

The above table is showing the sentiment % of Brands.

But I need the Brand Name Which has maximum Sentiment % in a Text Box.

Re: I need Brand Name.

Anonymous — Tue, 10 Dec 2013 06:31:34 GMT

can you post a sample app.

Re: I need Brand Name.

senpradip007 — Tue, 10 Dec 2013 06:33:55 GMT

can you please upload sample application?

Re: I need Brand Name.

Tue, 10 Dec 2013 07:13:45 GMT

Please find the attached application

Re: I need Brand Name.

Tue, 10 Dec 2013 07:21:44 GMT

But I want that We can also show the Brand Name without selection

Re: I need Brand Name.

Tue, 10 Dec 2013 07:58:40 GMT

Hello,

Did you try the IF statement.

If(Brand = max(aggr((count(Sentiment)/Count(TOTAL Sentiment))*100,Brand)), BrandName)

Thanks,

Angad

Re: I need Brand Name.

Tue, 10 Dec 2013 08:22:45 GMT

Thanks to all.

I found the solution . The solution is:-

MaxString(If(AGGR(Rank(count(Sentiment)),Brand)=2,Brand))

Re: I need Brand Name.

Tue, 10 Dec 2013 08:24:46 GMT

The above Solution is used to find the 2nd highest brand .

For Ist Highest brand Use:-

MaxString(If(AGGR(Rank(count(Sentiment)),Brand)=1,Brand))