Problems learning How to Use Set Analysis - functions in set analysis

Sat, 03 Dec 2016 18:24:54 GMT

Hi everyone,

I've been working with qlik sense since October and I have issues frequently trying to use examples I find on the web.

At this moment I use the 3.1 version in a qliksenseserver 10.7.1, "About" says. I don't use any client, just the web.

I'm not the IT administrator, so I can't set up the scripts or create new ones.

I only have the set analysis and the filters to work with.

I'm attaching the last file I'm using to learn.

Where could I find good examples or some papers to learn considering the situation above?

I find the help section is not useful to me.

To give you guys one example, I'm trying to use the follow function to calculate the sum of sales of the year:

Sum({$<[Calendar.Year]={"$(=max({1}[Calendar.Year]))"} [Orders.SalesValue])

The result is "-".

But, when I create a new object with max({1}[Calendar.Year]), Qlik Sense returns 2016.

I tried to replace " " for '' or nothing, but it still doesn't work.

Those situations don't allow me improve my skills on qlik sense.

I hope you can help me.

Thank you very much

Re: Problems learning How to Use Set Analysis - functions in set analysis

sunny_talwar — Sun, 04 Dec 2016 22:39:19 GMT

I think you forgot to close the set analysis correctly

Sum({$<[Calendar.Year]={"$(=max({1}[Calendar.Year]))"}>} [Orders.SalesValue])

Mon, 05 Dec 2016 01:11:03 GMT

I don't believe. It worked.

Thanks

sunny_talwar — Mon, 05 Dec 2016 01:17:12 GMT