Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

venkatasuresh
New Contributor III

Bar chart display top 5 positive and negative values remaining should be under others

Hi Everyone,

 

Here is my input bar chat

TOP5.PNGInput file

 

Expected output:

expected.PNGExpected outputPlease find the attached input QVW file

 

Thanks,

Suresh V.V

3 Replies

Re: Bar chart display top 5 positive and negative values remaining should be under others

Try this

Dimension

=If(Match(Country, 'GERMANY', 'USA', 'INDIA', 'CHINA'), Country, 'OTHERS')

Expression

=Sum(Sales)

Sorting

Match(If(Match(Country, 'GERMANY', 'USA', 'INDIA', 'CHINA'), Country, 'OTHERS'), 'GERMANY', 'USA', 'INDIA', 'CHINA', 'OTHERS')

image.png

venkatasuresh
New Contributor III

Re: Bar chart display top 5 positive and negative values remaining should be under others

Hi Sunny,

 

Thanks for your quick response:),

 

The below Measures are not a static, Those are Dynamic 

example: 1. For Jan-2019 (GERMANY,USA,INDIA,CHINA ) are Top 5

                    2. For Feb-2019  may be ( SWEDEN,RUSSIA,USA,UK) will be in top 5 (We are not sure which country will be in the                           top 5 every month)

 

Thanks,

Suresh V.V

 

 

 

venkatasuresh
New Contributor III

Re: Bar chart display top 5 positive and negative values remaining should be under others

Hi Guys,

 

Any suggestions here !

 

Thanks,

Suresh V.V