Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yunus_emre
New Contributor II

A function usage set analysis in the set analysis

Hi experts,

I'm trying to use set analysis in the set analysis, however, I'm getting an error.

My expression is like this:

=sum({<[Customer] = {"=sum({<Calendar = {">= $(=min(Calendar))"}>} sales_amount) >= 1000000"}>} aggr(sum(sales_amount), [Customer]))


I suppose that the problem is "Calendar = {">= $(=min(Calendar))".


Do you have any idea what correct syntax is?

1 Solution

Accepted Solutions
MVP
MVP

Re: A function usage set analysis in the set analysis

Try a different quote other than double quote for the inner search, like square brackets:

=sum({<[Customer] = {"=sum({<Calendar = {[>= $(=min(Calendar))]}>} sales_amount) >= 1000000"}>} aggr(sum(sales_amount), [Customer]))

2 Replies
MVP
MVP

Re: A function usage set analysis in the set analysis

Try a different quote other than double quote for the inner search, like square brackets:

=sum({<[Customer] = {"=sum({<Calendar = {[>= $(=min(Calendar))]}>} sales_amount) >= 1000000"}>} aggr(sum(sales_amount), [Customer]))

yunus_emre
New Contributor II

Re: A function usage set analysis in the set analysis

It is working, thank you so much

Community Browser