Potential Set Analysis Help

[NemoAndStitch22]

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

[juliensaintmaxent3113]

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

[NemoAndStitch22]

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

[juliensaintmaxent3113]

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

[NemoAndStitch22]

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!!

[juliensaintmaxent3113]

don't hesitate to contact us

have a nice day

[NemoAndStitch22]

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

[juliensaintmaxent3113]

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

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

[NemoAndStitch22]

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.

[juliensaintmaxent3113]

do you check the attachmnent diff.zip?