topic Detaching specific objects from a chart in QlikView

Detaching specific objects from a chart

Fri, 20 Jan 2012 15:29:46 GMT

Hello,

I would like to create a chart object that is detatched from one list box, but is still connected to all of the other objects in the QlikView document. How can I detatch specific objects from a chart?

Example:

Creating a line chart where the x-axis is static and shows all of the years from a database table, but the field for one of the list boxes is years.

Thanks,

Sean

Detaching specific objects from a chart

Sun, 22 Jan 2012 01:44:09 GMT

hello Sean,

i guess what you mean is how to ignore selections made in particular fields.

to do so you'll use the set analysis as follows:

sum({$<Field1=, Field2=>} Sales)

this example will sum up the sales ignoring selections in Field1 and Field2.

if you want to ignore all selections, then this will do the job:

sum({1} Sales)

hope that this is what you're looking for.

Re: Detaching specific objects from a chart

IAMDV — Sun, 22 Jan 2012 01:56:42 GMT

Hi Sean,

jp_bakhache is right. You can use..

Sum({$<Field1= >} Sales)

Where Field1 is ignored. However if you wanted to do other way around then please use the below expression. Everything will be ignored expect the Gender field and you can add more field names by adding the comma (,) after Gender.

=COUNT({$<[$(=Concat({1<$Field-={'Gender'}>}distinct $Field,'],[')&']=')>} Resp_ID)

In the above example except 'Gender' everything will be excluded.

I hope this helps!

Cheers - DV

Detaching specific objects from a chart

Wed, 25 Jan 2012 09:41:09 GMT

Great Solution DV, i was looking for something like that to separate the min and max possible (selected) dates from user selections within product or company fields, so that the user does get a whole month if he selects it, even when the selected product just was sold on a single day. And to exclude a 100 + fields within set analysis was not the way I wanted to go thx a lot