detach automatic

[#1]

Hello,

I have several charts that I want to put on the same page. Problem is that they all need a different pré selection so that does not simply work because if I select a value, only one chart is alright and the other ones wrong. On different pages it's easy to fix with an action to preselect a value but this does not work when I put all charts on the same page.

When I manualy detach the charts after selecting the preselection for every chart everything works fine but when I close my Qlikview en open it again, the charts are attached again.

How can I get my charts to always be detached?

[rbecher]

Hi,

you could use set analysis on all expressions of the "detached" charts to exclude selection:

sum( {1} Sales)

- Ralf

[#3]

Sorry, newbie here. How does that work and where can I put that?

[rbecher]

There is a section in the online help.

If you add {1} in the expression it will disregard the selections for this expression.

[#5]

Hey Ralf, thx for the explanation but I do not want to disregard the selections for the expression. Every chart needs a differtent selection and my problem is to get these selections within every seperate chart on the same tab/page.

When I manualy select the type for every charts and detach them after selecting the type I get what I want.

When I save the file and open it again, everything is attached again.

I want every chart to work on the same tab/page without the need of selecting a type first. Is this possible?

[#6]

Hi Richard

You can get a unique selection for each object using set analysis.

Look at the examples in the QV help. You can disregards certain field selections by setting them to nothing {Year=} and set other fields to specific values that will only be used for that object.

/John

[#7 · Accepted solution]

thx I managed to solve the problem. The syntax must be:

sum( {1<type= {verblijf}>} Dagen) - sum ({1<type= {verblijf}>} Totaal) / (365) * (334)