Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
with conditional expressions
HTH
André Gomes
Try like this
sum({<[Price Movement]={0}>}[Price Movement])
Thanks for your reply.
MinString also returns null value, I do not want null value in the report.
Thanks for your reply.
Giving error.
try like
if(PriceMovement=0,PriceMovement)
Hi,
Do you have a Field name as Price Movement?
In your expression PriceMovement is a Label and showing in blue color.
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
Yes PriceMovement is column label name.
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