Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
somebodysomeone
Contributor II
Contributor II

Graph For BTP (below target positive) Values

Hello there,

 

I couldnt find any solution for my below target positive values. Those values are like cost measures or ranks. 

 

For example, in my graph there are just 3 rows, 2 colums and these values are RANK. In any graph in Qlik Sense 3's bar is bigger then 2, 2's bar is bigger then 1 and 1 is the smaller bar. But being 1st is better then 2nd in ranking.

LOAD * INLINE [

    Person, Rank   

    A, 2

    B, 1

    C, 3  

];

Shortly, how can i show 1 bigger then 2, 2 bigger then 3 and 3 is the smallest column like the attached picture? 

 

Ty and have a nice day!rank.jpg

 

* I also want to show values on bar, that's why i cannot use negative values.

Labels (2)
5 Replies
PunamWagh
Contributor III
Contributor III

if Category_desc indicates rank of category then u can use below as measure:

Rank(Sum(Category_desc))

Regards,

Punam 

NhanNguyen
Contributor III
Contributor III

You can try adding '-' in front of your measure inside the rank (). It will reverse the ranking.
somebodysomeone
Contributor II
Contributor II
Author

Sorry about column names. I  fixed the name.

 

In my situation i dont do any calculation or use any function. I just want to show values (Rank column) on graph, but i want smaller value must be shown with bigger a bar, and the bigger value must be shown with a smaller bar.

somebodysomeone
Contributor II
Contributor II
Author

It's ok for bars but i also want to show values on bars.

somebodysomeone
Contributor II
Contributor II
Author

no solution yet 😕