Qlik Community

New to Qlik Sense

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

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 (4)
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 😕