topic Custom Sort for Straight table in Qlikview in QlikView

Custom Sort for Straight table in Qlikview

hkg_qlik — Mon, 10 Jan 2011 06:39:32 GMT

Hi,

When I make any Straight table I can only assign a single sort (ASC or DESC) on any one of the column name in the table.

Is there a way where I can provide interactive sort option for each Expression in the Straight table for the end user?

For example: I have a Revenue & COGS table with Customer Name, Number, Sales Amt, Revenue Amt, Invoice Date and so on..

In the present scenario I can develop a Straight table with any of the above mention expression for a interactive sort: Like Revenue Amt (DESC)

Can we have the same type of sorting available for each expression on the same table?

Thanks,

Custom Sort for Straight table in Qlikview

hkg_qlik — Tue, 11 Jan 2011 01:25:22 GMT

Can Anyone help me on sort options available in Qlikview.

Custom Sort for Straight table in Qlikview

johnw — Tue, 11 Jan 2011 01:54:25 GMT

The end user can sort any column ascending or descending by double clicking on the column heading. To sort by multiple columns, they just need to double click on the column headings in the correct order. Is that what you're asking?

Custom Sort for Straight table in Qlikview

hkg_qlik — Tue, 11 Jan 2011 02:19:47 GMT

Oh yes!! That's simple...

Thanks John.

Custom Sort for Straight table in Qlikview

Mon, 23 Jan 2012 21:45:21 GMT

Would it be possible to do something similar for bar charts?

For example, someone might want to see a bar chart sorted by

Numerical Value of expression
Alphabetical order of the dimension