topic Re: Comparison field in QlikView

Comparison field

Anonymous — Tue, 20 May 2014 18:45:45 GMT

Hi,

I have a chart. I have 2 fields: Campaign and date. (filters)

I want to select from variable Campaign (for example Campaign A) and from comparison variable Campaign (for example Campaign D) and compare them.

How can I set up independent variables Campaign?

or help with your idea.

Please find attached file.

Thanks,

Re: Comparison field

MarcoWedel — Tue, 20 May 2014 21:12:14 GMT

Hi Vladimir,

maybe alternate states could be a solution for you:

at first generate an alternate state like this:

use this state in your comparison campaign selection chart:

add the alternate state to your chart's set expressions:

the result should look like this:

maybe you also have to adjust your set exprsssions in order to let the selections in other fields also apply to your comparison expressions.

see help:

Example:

sum({[Group 1]<Region = $::Region>} Sales)

This syntax uses the selections in the Region field from the default state and modifies the state ‘Group 1’ with them. The effect is to keep the Region field "synchronized" between the default state and ‘Group 1’ for this expression.

hope this helps

regards

Marco

Re: Comparison field

Anonymous — Wed, 21 May 2014 13:51:44 GMT

It looks like I need it.

But I do something wrong.

Could you please send me your example.

Thanks,

Re: Comparison field

Anonymous — Wed, 21 May 2014 15:03:41 GMT

I think I solve an issue.

But I use my expression. I don't know how to use your expression.

I have selection by Campaign and/or date.

I'd like to fix my expression. Because when I select from Comparison period, my Campaign period disappears.

I need to re-select date from Campaign period again.