# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor III

## Potential Set Analysis Help

Hiya,

I'm trying to create a table in Qliksense and want it to look something like this:

Currently I've managed to get this..

I'm just wondering if anyone knows how to add the Year on year difference.. This needs to change when the filter changes the selection.. I think I need to use set analysis but I can't work out how to make it happen.

Any help would be greatly appreciated.

Many Thanks,

Megan

Labels (6)

13 Replies
Partner

## Re: Potential Set Analysis Help

hi,

• in first , create fields month and year which are separeted
• in the second time:

sum({\$<fieldyear={"\$(=max(Year))"}>}Volume)

sum({\$<fieldyear={"\$(=max(Year)-1)"}>}Volume)

the same for value

• in the third time, in the label expression :

='Volume '&max(year)

= 'Volume '&(max(year)-1)

• to finish, leave dimension month-year in the graphic.

After, you can realize evolution or difference between values with the expression or with the function column

Bye

New Contributor III

## Re: Potential Set Analysis Help

I don't quite get what you mean... I need the month + Year to be a field together, not separate

Partner

## Re: Potential Set Analysis Help

the problem of you mont+year is the format

it's a string so you can't apply a set analysis with -1 to have the year past.

so if you split month and year it's easy to apply a set analysis

and in your graphic you can show month and year

show the attachment, i think it will be more esay to unsderstand what i mean

sorry my english is bad 🙂

Bye

New Contributor III

## Re: Potential Set Analysis Help

Okay, I think I understand... I don't think my lack of qliksense understanding helps!

In your test data, it's still got the 4 columns, what I need is an additional 2 columns that do:

Value of Selected date 1 - Value of Selected Date 2

Volume of Selected date 1 - Volume of Selected Date 2

to give the differences, then that would need to change as my selections change. I've already got the table changing as my selections change..

It might not even be set analysis I need to use to get this to work..

Hopefully that helps. Thanks!!

Partner

## Re: Potential Set Analysis Help

have a nice day

New Contributor III

## Re: Potential Set Analysis Help

Is anyone else able to help? I've not managed to get to a solution as of yet.

Partner

## Re: Potential Set Analysis Help

in my first post, i give you solutions to make difference

in attachmnet, you find 2 solutions to make difference between year

New Contributor III

## Re: Potential Set Analysis Help

You've given me the first step which I've already done. It's the calculating difference based on my current selections that I need help with.

Partner

## Re: Potential Set Analysis Help

do you check the attachmnent diff.zip?