Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis : operator on modified identifiers ?

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

2 Replies

HI

Try like this

Year,Month as dimension..

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

Hope it helps

Thanks & Regards,
Mayil Vahanan R
Not applicable

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