topic Re: Detach object from tabs selections in QlikView

Detach object from tabs selections

Mon, 18 Nov 2013 06:49:19 GMT

Hi all,

in my landing dashboard I have a text Object with the next Expression:

=num(SUM({1<RUN_ID = {$(vMax_Run)}>} AGGR(SUM(DISTINCT SUBSCRIBER_COUNT), RunChunkFlow_ID))

,'#,##0','.',',')

it was created by your help here, and works perfectly.

But, I found that when I do selections in my other tabs that influence the RunChunkFlow_ID, then the value changes, and I don't want it to happen.

I tried to put 1<RunChunkFlow_ID> and it didnt work.

do I have a way to detach an object from the selections made in other tabs?

Thanks,

Boris

Mon, 18 Nov 2013 07:05:26 GMT

Hi,

You can use Alternate state for this.Follow these steps:

1. Add one alternate state from Setting>>Document Property >>In general tab>> Alternate State.

2. Now goto property of objects which you want to include >> In General tab >> Select your created state.

3. Now, If you change your filter which have same state name, only those objects value will be change.

4. One more thing, you can also add alter state for a particular tab from its property.

I hope this helps you.

Regards,

Ashutosh Sharma

Mon, 18 Nov 2013 07:11:13 GMT

where do I choose the created state?

Mon, 18 Nov 2013 07:40:18 GMT

Hi,

First you have to create one alternate state by using my first option. after that only it will show here Alternate State option like this image:

Regards,

Ashutosh