Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
NemoAndStitch22
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:

Capture.PNG

Currently I've managed to get this.. Capture2.PNG

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

13 Replies
Partner
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

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

NemoAndStitch22
New Contributor III

Re: Potential Set Analysis Help

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

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
Partner

Re: Potential Set Analysis Help

don't hesitate to contact us

have a nice day

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

NemoAndStitch22
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
Partner

Re: Potential Set Analysis Help

do you check the attachmnent diff.zip?