how to display revenue with condition?

[#1]

hi,

I created straight table in that straight table have three fields Id, customer, revenue.I want to display customers revenue below 50000 and display below 100000 how write expression in straight table.

below this image.

                                                                                     Thankyou

Regards:

madhu                                                        

[Gysbert_Wassenaar]

You can use Dimension Limits to add these constraints. Choose the Show only value that are: option and choose Less than 50000 exact value.

[sunny_talwar]

For customer's below 50,000 you can try this:

=Sum({<Revenue = {"<50000"}>}Revenue)

similarly you can do this for customer's with below 100,000 revenue

=Sum({<Revenue = {"<100000"}>}Revenue)

I hope this will help.

Best,

Sunny

[#4]

I write  your expression but it shows error.

[sunny_talwar]

Since QV is case sensitive did you try this??? revenue with lower case r???

=Sum({<revenue = {"<50000"}>}revenue)

[#6]

I try like this but it show error

[sunny_talwar · Accepted solution]

Are you putting 2 single quotes (') or one double quote (")?? You need one double quote here

[anat]

he is using 2 single quotes (') ,so use double quote.

[sunny_talwar]

Have a look at the attached qvw file.

Best,

Sunny

[#10]

Thankyou  its working