topic Straight Table Chart - Sorting in QlikView

Straight Table Chart - Sorting

Tue, 02 Jul 2013 14:56:24 GMT

All,

I am using a straight table chart with one dimension and multiple expressions that relates to that dimension.

(All these dimensions and expressions came out as a column for the table - which is fine for me)

No I want to sort the entire table based on a 'field' which is not part of the table that is formed but that is available in the list of 'fields' for me to add to the table.

[In short: I have A, B, C, D, E fields. I want to bring A, B, C, D in the table and want to sort them based on 'E' field.]

Can someone help me how to do this?

Thanks in advance.

Re: Straight Table Chart - Sorting

swuehl — Tue, 02 Jul 2013 15:16:10 GMT

Maybe chart properties - sort tab - sort by expression and enter the field name?

Re: Straight Table Chart - Sorting

Tue, 02 Jul 2013 15:20:36 GMT

Thanks, swuechi.

I tried this one previously also it seems like working fine. But when I do that it is missing some inbetween rows.

So, I thought that was wrong.

may be, that is the right direction and I am missing those rows because of someother other conditions.

Re: Straight Table Chart - Sorting

swuehl — Tue, 02 Jul 2013 15:29:04 GMT

How does your field you want to sort by looks like? Does it have a value for each of your dimension values? And does it have the same value for same dimension value, if dimension value can appear multiple times in your table?

Re: Straight Table Chart - Sorting

Tue, 02 Jul 2013 15:36:05 GMT

It does have a unique value for each dimension values and I can clearly see some inbetween values are missing after loaded. Like 5001, 5003, 5004, 5007, 5010 etc...

Re: Straight Table Chart - Sorting

swuehl — Tue, 02 Jul 2013 15:55:09 GMT

Sorting by this additional field does remove lines from your straight table?

Hm, can't think of a reason right now. Could you upload a small sample?

Re: Straight Table Chart - Sorting

Tue, 02 Jul 2013 17:21:15 GMT

Thanks swuehi.

I found the solution. Actually, I was trying to populate data with a dimension field which is not appropriate.

I tried using different dimension field, it worked perfectly.