topic Re: Potential Set Analysis Help in Visualization and Usability

Potential Set Analysis Help

NemoAndStitch22 — Sat, 16 Nov 2024 21:36:22 GMT

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

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Mon, 14 Jan 2019 15:28:49 GMT

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

Re: Potential Set Analysis Help

NemoAndStitch22 — Mon, 14 Jan 2019 16:10:41 GMT

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

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Mon, 14 Jan 2019 16:27:04 GMT

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

Re: Potential Set Analysis Help

NemoAndStitch22 — Tue, 15 Jan 2019 09:19:37 GMT

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

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Tue, 15 Jan 2019 09:40:00 GMT

don't hesitate to contact us

have a nice day

Re: Potential Set Analysis Help

NemoAndStitch22 — Tue, 15 Jan 2019 09:52:10 GMT

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

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Tue, 15 Jan 2019 09:59:18 GMT

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

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

Re: Potential Set Analysis Help

NemoAndStitch22 — Tue, 15 Jan 2019 10:03:51 GMT

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.

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Tue, 15 Jan 2019 10:05:22 GMT

do you check the attachmnent diff.zip?

Re: Potential Set Analysis Help

NemoAndStitch22 — Tue, 15 Jan 2019 10:22:25 GMT

Yes.

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Tue, 15 Jan 2019 10:25:20 GMT

and inside you don't find difference between two values?

like that:

Re: Potential Set Analysis Help

NemoAndStitch22 — Tue, 15 Jan 2019 10:28:16 GMT

No, I've double checked the file, I am just getting the same data as the original attachment.

Re: Potential Set Analysis Help

juliensaintmaxent3113 — Tue, 15 Jan 2019 10:34:52 GMT

it's a mistake of my part , i'm sorry

please check in the attachment the good app with two methods to calculate difference