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.
the same for value
= 'Volume '&(max(year)-1)
After, you can realize evolution or difference between values with the expression or with the function column
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 🙂
Okay, I think I understand... I don't think my lack of qliksense understanding helps! :smileylol:
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!!