topic Re: straight table in QlikView

straight table

Fri, 07 Feb 2014 09:12:28 GMT

I have a straight table which is having multiple dimensions and an expression.

I have sorted the rows based on expression. It opens another sheet when I click on a particular cell.

Along with this the order of rows also changes. Is there any way to avoid this(change in order of rows on selecting a cell)

Re: straight table

MK_QSL — Fri, 07 Feb 2014 09:14:09 GMT

It would be better if you enclosed your sample apps.

Re: straight table

Fri, 07 Feb 2014 09:42:37 GMT

Thanks for the reply

I cannot attach my sample.

I think the question is clear enough. Please let me know if you need more details.

Re: straight table

kiranmanoharrode — Fri, 07 Feb 2014 10:05:33 GMT

Hello Kavita,

Just check Field Level trigger (on Select) of your application.

Just click on the particular cell and check in current selection box, i.e. which field is getting selected

Go to settings>> Document properties >> Triggers >> Field Event Triggers >> check for the field which you have identified in Current selection box.

Then manipulate triggers as per your requirement.

Regards
Kiran Rode

+91 8976977897

Re: straight table

Gysbert_Wassenaar — Fri, 07 Feb 2014 10:07:22 GMT

Maybe. It sounds like you need to make the expression you sort on independent of the selection you make. See for example this discussion: List Box sorting based on Expression. Without looking at your document it's impossible to tell you what to do or if it is even possible at all.

Re: straight table

Fri, 07 Feb 2014 12:04:19 GMT

Here is a sample.

My requirement is :

Rows having |A_State-B_State| high value need to be displayed at the top(in descending order).

Please let me know ur inputs on this.