topic Re: Issue in sorting in QlikView

Issue in sorting

Fri, 01 May 2015 20:58:12 GMT

Hi,

Need some guidance to deal with this requirement in straight table.

I want all the schedules in red on the top. And I have given following expression for background colour.

if([Prior Month End Original Term] <> [Month End Original Term] or

    [Prior Month End Commencement Date] <> [Month End Commencement Date] or

    [Prior Month End Maturity Date] <> [Month End Maturity Date] or

    [Prior Month End Interim Rent] <> [Month End Interim Rent] or

    [Prior Month End Accrual Code] <> [Month End Accrual Code] or

    [Prior Month End Lessor Yield] <> [Month End Lessor Yield] or

    [Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy], rgb(255,0,0),null())

Can someone help me with this?

Thank you in advance.

Please find screenshot attached.

Regards,

Aditya

Re: Issue in sorting

MarcoWedel — Fri, 01 May 2015 21:08:16 GMT

sorting expression for schedules ascending:

[Prior Month End Original Term] <> [Month End Original Term] or

    [Prior Month End Commencement Date] <> [Month End Commencement Date] or

    [Prior Month End Maturity Date] <> [Month End Maturity Date] or

    [Prior Month End Interim Rent] <> [Month End Interim Rent] or

    [Prior Month End Accrual Code] <> [Month End Accrual Code] or

    [Prior Month End Lessor Yield] <> [Month End Lessor Yield] or

    [Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy]

Hope this helps

regards

Marco

Re: Issue in sorting

Fri, 01 May 2015 21:12:08 GMT

Thank you Marco

Re: Issue in sorting

petter — Fri, 01 May 2015 21:27:02 GMT

Your color expression could also be used as an expression to sort on because the expression will evaluate to -1 or 0.

-1 will come on top if you sort ascending and 0 after the -1...

So:

([Prior Month End Original Term] <> [Month End Original Term] or
[Prior Month End Commencement Date] <> [Month End Commencement Date] or
[Prior Month End Maturity Date] <> [Month End Maturity Date] or
[Prior Month End Interim Rent] <> [Month End Interim Rent] or
[Prior Month End Accrual Code] <> [Month End Accrual Code] or
[Prior Month End Lessor Yield] <> [Month End Lessor Yield] or
[Prior Month End LeasePak Vendor Subsidy] <> [Month End Vendor Subsidy])

Could be put in as an expression in the sort tab for your chart - make sure to select a column that is right for it and then check for Expression in Sort by. Make sure that you put the priority right by Promoting the column to the top...

Re: Issue in sorting

petter — Fri, 01 May 2015 21:27:45 GMT

a bit too slow and late me I mean...

Re: Issue in sorting

Mon, 04 May 2015 14:36:43 GMT

Thanks, I appreciate your help Petter.