topic Re: Sorting the data in straight table in QlikView

Sorting the data in straight table

Wed, 25 May 2016 17:44:58 GMT

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 — Wed, 25 May 2016 18:17:05 GMT

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

Thu, 26 May 2016 06:48:14 GMT

Thanks sunny.

The set analysis shows error in the expression.

i tried debugging it but couldnt..

sunny_talwar — Thu, 26 May 2016 09:38:54 GMT

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?

Thu, 26 May 2016 10:19:41 GMT

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