Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to display revenue with condition?

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.

straight table.PNG

                                                                         

                                                                                     Thankyou

Regards:

madhu                                                        

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

10 Replies
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.


talk is cheap, supply exceeds demand
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

Not applicable
Author

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)

Not applicable
Author

I try like this but it show error

error expression.PNG

sunny_talwar

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

anat
Master
Master

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

sunny_talwar

Have a look at the attached qvw file.

Best,

Sunny

Not applicable
Author

Thankyou  its working