Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijayqlikproject
Contributor
Contributor

HOW TO SHOW OUTSATANDING FROM 10 LAKH TO 25LAKS RANGE IN BAR CHART

I have 

Client name //Dimension

Total outstanding //measure

I want to show Total out standing between 10lakh to 25lakh in bar chart 

How to write syntax in measure 

5 Replies
Vegar
MVP
MVP

Maybe you can do this using set analysis 

Sum({<Lakht={">=10<=25"}>}Outstanding)

dushyant
Contributor III
Contributor III

Hi Vegar,

I tried the expression Sum({<Lakht={">=10<=25"}>}Outstanding) but still its showing incorrect values.

Can you tell me what is Lakht in the Expression?

Ankit1988
Contributor III
Contributor III

Lakht is feild name as per syntex of set modifier

In this Case field name  = Outstanding

Iswarya_
Creator
Creator

HI @Vijayqlikproject ,

Sum({<"Total outstanding"={">=1000000<=2500000"}>}"Total outstanding")

 

Ankit1988
Contributor III
Contributor III

Shows client outstanding 0 to 5 Lakhs.

issue : there is value above 5 lakhs is also show