Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ksharpes
Creator
Creator

Sort by Expression Bar Chart

Hello,

I am using the following expression to sort data on my Bar Chart 

Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

Which gives me the below

clipboard_image_0.png

As the data is showing values from last month vs 6 months ago, if there are no values against the 'group' from last month it doesn't sort it correctly.

How do I get around this?

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Match(Only({1} [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

or

Match(Only({1} TOTAL <[Coverage Group (All)]> [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

 

View solution in original post

3 Replies
sunny_talwar

May be try this

Match(Only({1} [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

or

Match(Only({1} TOTAL <[Coverage Group (All)]> [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

 

View solution in original post

Yoshidaqlik
Creator II
Creator II

Hello

Try:

Min(Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0'))

 

Regrs

 

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
ksharpes
Creator
Creator
Author

Both options worked, I used 

Match(Only({1} [Coverage Group (All)]),'Short','Med','Long','Very Long','Dead Stock','No Sales Data','NYA','NLA','PROMO','Cat 0')

 

Many thanks.