Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

julian_rodrigue
Valued Contributor

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

Tags (4)
1 Solution

Accepted Solutions
Employee
Employee

Re: Set Analysis on Qlik Sense

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

10 Replies
jaimeaguilar
Valued Contributor II

Re: Set Analysis on Qlik Sense

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
Valued Contributor

Re: Set Analysis on Qlik Sense

Hello,

In Qlik Sense Set Analysis works similarly QlikView.


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

Employee
Employee

Re: Set Analysis on Qlik Sense

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

julian_rodrigue
Valued Contributor

Re: Set Analysis on Qlik Sense

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 !

Employee
Employee

Re: Set Analysis on Qlik Sense

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

Mike

fernando_tonial
Valued Contributor

Re: Set Analysis on Qlik Sense

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

Best regards.

Tonial.

fkeuroglian
Honored Contributor

Re: Set Analysis on Qlik Sense

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

jtg
Valued Contributor

Re: Set Analysis on Qlik Sense

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

etk
Contributor

Re: Set Analysis on Qlik Sense

Hi-

Dynamic labeling on measures is not currently supported.

Thanks a lot!