topic Re: Getting Values from 1 control and use it in anther in QlikView

Getting Values from 1 control and use it in anther

Fri, 22 Aug 2014 07:07:39 GMT

Some one please help!!!

I had a existing Straight Table in my report which display the Top N Numbers of customers based on their purchase.

Now I'm adding another straight table to display customer preference. my new control should:

For Example:

Existing table:

My table should display:

When selection change and control display:

My table should display:

Is there a way for me to get a control's data and sorting order???

CELAMBARASAN — Fri, 22 Aug 2014 07:14:55 GMT

What is the sorting option you are using in existing straight table? And how it displays the customers?

Fri, 22 Aug 2014 07:19:07 GMT

The default sort order is desc on the total sales but the calculation of the total sales is complex.

CELAMBARASAN — Fri, 22 Aug 2014 07:34:09 GMT

Refering the object from another object is not possible.

Try like this

Copy the expression Existing straight table and add it to the Preference table. In presentation tab, select the expression and mark it as hidden.

Sort tab, do the same sorting for the expression which you did for the first table.

Fri, 22 Aug 2014 08:33:03 GMT

I did this. but the problem is my total value sum up is different from the existing table.