Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: how to display revenue with condition?

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

10 Replies

Re: how to display revenue with condition?

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

Re: how to display revenue with condition?

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

Re: how to display revenue with condition?

I write  your expression but it shows error.

Re: how to display revenue with condition?

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

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

Not applicable

Re: how to display revenue with condition?

I try like this but it show error

error expression.PNG

Re: how to display revenue with condition?

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

anat
Contributor

Re: how to display revenue with condition?

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

Re: how to display revenue with condition?

Have a look at the attached qvw file.

Best,

Sunny

Not applicable

Re: how to display revenue with condition?

Thankyou  its working

Community Browser