Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatasuresh
Creator
Creator

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

Hi Everyone,

 

Here is my input bar chat

Input fileInput file

 

Expected output:

Expected outputExpected outputPlease find the attached input QVW file

 

Thanks,

Suresh V.V

3 Replies
sunny_talwar

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
Creator
Creator
Author

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
Creator
Creator
Author

Hi Guys,

 

Any suggestions here !

 

Thanks,

Suresh V.V