topic Re: Hold the data in Table based on previous selections also in QlikView

Hold the data in Table based on previous selections also

jagannalla — Tue, 24 May 2011 14:02:05 GMT

Hi,

- I've a barchart with dimension i.e group and also with the one slider & straight table.

- When i change the slider the data is reflecting in bar chart and table based on group selection.

- Now, i'll select the another group selection and i'll change the slider then i should get current selection group data along with previous selection of group data in the straight table .

How can i do this?

Hold the data in Table based on previous selections also

Tue, 24 May 2011 14:07:27 GMT

I don't understand exactly what you are trying to accomplish. Can you give more info about the table and the slider? What values does the slider hold? How do these relate to your chart and what is your group?

You would probably need a way to store the contents of the slider and/or the selected group in a variable. Then base you chart off the values in the variable along with the slider values. I can't be anymore specific than that without some more information.

Re: Hold the data in Table based on previous selections also

jagannalla — Tue, 24 May 2011 14:51:08 GMT

Hi Miller,

I attached my screenshots can you plz check it once.

- If i selected BCShortfillingTimeA you can see ' N' value in the 'Avg' . Same value can you see in the straight table.

- Now i'll select another group then i'll get another 'N' value in the 'Avg'. But i should get the value in table box along with previous 'N' Value in straight table.

eg: 522 + 32 =554

Re: Hold the data in Table based on previous selections also

Tue, 24 May 2011 15:07:04 GMT

HI Jagan,

use peek, it must work for you

see the below example. B is the 'N' field for you. Replace B with N in the below formula

LOAD A, B, numsum( B, peek( 'Bsum' ) ) AS Bsum...;

Regards

Sravan

Hold the data in Table based on previous selections also

rwunderlich — Tue, 24 May 2011 16:10:18 GMT

You can union the current selections and the previous selection together using a set in your expression. $1 indicates the previous selection. For example:

=sum({$ + $1}SalesAmount)

-Rob