Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_rodriguez
Partner - Specialist
Partner - Specialist

Set Analysis on Qlik Sense

Hello,

Where can I find documentation about this?

How can I create a visualization with year vs previous year, for example?

Thanks in advance.

Julian

1 Solution

Accepted Solutions
Michael_Tarallo
Employee
Employee

Jaime Aguilar is correct - the syntax is the same. The best way to do this is to create fields on the fly - Dimension or Measure - using the found under the master items section when developing. You can also enter the expression for the measure or dimension from the properties panel of the chart object in the appropriate section.

Take a look at this video to see how it is done: Using The Master Library (video)

I also found this utility very helpful to learn and assist in creating Set Analysis statements:

Set Analysis Wizard for QlikView | qlikblog.at

Regards,

Michael Tarallo - Qlik

Regards,
Mike Tarallo
Qlik

View solution in original post

10 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

For what I've seen in previous videos and in my first impressions from Sense, The back-end and syntaxis like set analysis will remain the same, so you can type set analysis the same way you've been doing all this time, but the interface relates more to the ajax one than to the desktop we were used to,

regards

fernando_tonial
Employee
Employee

Hello,

In Qlik Sense Set Analysis works similarly QlikView.


24-07-2014 13-04-24.png

Don't Worry, be Qlik.
Michael_Tarallo
Employee
Employee

Jaime Aguilar is correct - the syntax is the same. The best way to do this is to create fields on the fly - Dimension or Measure - using the found under the master items section when developing. You can also enter the expression for the measure or dimension from the properties panel of the chart object in the appropriate section.

Take a look at this video to see how it is done: Using The Master Library (video)

I also found this utility very helpful to learn and assist in creating Set Analysis statements:

Set Analysis Wizard for QlikView | qlikblog.at

Regards,

Michael Tarallo - Qlik

Regards,
Mike Tarallo
Qlik
julian_rodriguez
Partner - Specialist
Partner - Specialist
Author

Hello Michael,

Thanks, I was a little confused with the new color squema and I had an error on my expression.

Other question, is it possible give a dynamic name to a Dimension/Expression?

For example:

='Sales ' & Max(Year)

or

='Sales ' & Max(Year) -1

Thanks !

Michael_Tarallo
Employee
Employee

Hello Julian - good question - I will find out for you.

Mike

Regards,
Mike Tarallo
Qlik
fernando_tonial
Employee
Employee

Hello, I tried this, but this is not working in this version

Best regards.

Tonial.

Don't Worry, be Qlik.
fkeuroglian
Partner - Master
Partner - Master

Julian, i think that all about set analysis and the part of script will be the same, only some things could be change but the essencialy is the same.

Good luck

Fernando

Qlik_Trigg
Employee
Employee

You cannot have a dynamically generated name for a measure in Sense

elif-tutuk
Former Employee
Former Employee

Hi-

Dynamic labeling on measures is not currently supported.

Thanks a lot!