Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis : operator on modified identifiers ?


I would like to know if something is possible through Set Analysis.

Let's take an example:

There is a KPI for all months of the last three years.

We want to display the value for each last month of each year (december 2010, december 2011, november 2012)

To make it easier, let's say that November is stored in the variable "MyMonth"

Can I do something like : sum( {$<Month=12, Year={"<$(=max(Year))"}>} + {$<Month={$(MyMonth)}, Year={$(=max(Year))}>} KPI)

More general, can I use operators this way : sum({$<.....>} + {$<.....>} KPI) ?

If it is possible, what would be the syntax ?

Many thanks


2 Replies

Re: Set Analysis : operator on modified identifiers ?


Try like this

Year,Month as dimension..

=Sum({<Month={'$(=Max(Month))'}>}KPI) as expression

Hope it helps

Not applicable

Re: Set Analysis : operator on modified identifiers ?


Thanks for your proposal ! Unfortunately, this is not really what I would like to do.

Basically, I would like to know if it is possible to do something like sum({$<.....>} + {$<.....>} KPI)

It is for instance possible to do sum({1-$} KPI)... but is it possible, in this case, to modify the identifiers ?

Or... Let's take another example...

I would like to display in a graph how many customers (in the active selection) have bought red shoes and green ties.

So the formula would be something like :

count({$<red shoes definition>} + {$<green ties definition>}Customers)


Community Browser