How to filter the data in expressions ?

[#1]

Hi Guys,

How to filter the data in expressions ?

Below is the chart - Straight table

Quote Name	First Date Quote	Last Date Quote	Price Movement

1. Quote Name is the dimension.

2. First date Quote is expression - Max(Quote date) - 1, Bid value.

3. Last date Quote is expression - Max(Quote date),  Bid value.

4. Price Movement is First Date Quote - Last Quote Date.

So query is in Price Movement i want to filter data as only value with 0.

How can i achieve the above ?

[agomes1971]

Hi,

with conditional expressions

HTH

André Gomes

[avinashelite]

Try like this

sum({<[Price Movement]={0}>}[Price Movement])

[#4]

Thanks for your reply.

MinString also returns null value, I do not want null value in the report.

[#5]

Thanks for your reply.

Giving error.

[avinashelite]

try like

if(PriceMovement=0,PriceMovement)

[#7]

Hi,

Do you have a Field name as Price Movement?

In your expression PriceMovement is a Label and showing in blue color.

[#8]

This also shows the null values.

I do not want null values in the report only with Price Movement as 0 to be shown.

Example:

if PriceMovement = 0 it displays 0 as PriceMovement otherwise it shows '-' in PriceMovement column.

So i dont want '-' to see.

Please help

[#9]

Yes PriceMovement is column label name.

[effinty2112]

Hi Girish,

Try adding this as a calculated dimension to your chart:

=Aggr(if(FirstSortedValue([Bid Value],-[Quote Date]) - FirstSortedValue([Bid Value],-[Quote Date],2)=0,'No','Yes'),[Quote Name])

Then (hopefully) selecting 'No' in this calculated dimension will ask QV to select those values in the [Quote Name] dimension for which the Price Movement is zero.

Regards

Andrew