topic Set Analysis : operator on modified identifiers ? in QlikView

Set Analysis : operator on modified identifiers ?

Wed, 28 Nov 2012 18:06:21 GMT

Hello,

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

Pierre

MayilVahanan — Wed, 28 Nov 2012 18:17:14 GMT

Try like this

Year,Month as dimension..

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

Hope it helps

Mon, 03 Dec 2012 13:05:16 GMT

Hi,

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)

Thanks