Sorting the data in straight table

[#1]

Hello ,

I need to only show those order_ids where shipment_date >= order_date in the straight table.

please help me with this.tried few things but not working.

Appreciate your help.

Regards,

Jaya

[sunny_talwar · Accepted solution]

May be like this in set analysis:

{<order_ids = {"=shipment_date >= order_date"}>}

or you can use calculated dimension:

If(shipment_date >= order_date, order_ids)

and then select 'Suppress When Value Is Null' on the dimensions tab

[#3]

Thanks sunny.

The set analysis shows error in the expression.

i tried debugging it but couldnt..

[sunny_talwar]

So is the issue resolved now? Why did you close this thread by marking the response as correct if the issue has not resolved yet?

[#5]

Hello Sunny,

This issue is resolved.I used the calculated dimension option.

Thanks for helping me out.I an new to qlikview and struggling with simple things also.

Regards,

Jaya