Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks sunny.
The set analysis shows error in the expression.
i tried debugging it but couldnt..
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?
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