Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting the data in straight table

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

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

View solution in original post

Not applicable
Author

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?

Not applicable
Author

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