Obtaining the following set for a selection

[#1]

Hi,

I am loading into Qlikview a table with this format:

Invoice	Date	Month	Client Name	Category
2223	01.01.2014	January	Harry	Home
2224	10.01.2014	January	Harry	School
2225	20.01.2014	January	Paul	Home
2226	30.01.2014	January	John	Acessories
2227	04.02.2014	February	Paul	Technology
2228	10.02.2014	February	Paul	School
2229	20.02.2014	February	Christie	Home
2230	21.02.2014	February	Michael	Technology
2231	03.03.2014	March	Harry	Plants

My requirement is:

When I select a Month and a Category I need to represent in a bar chart the set of all the following Invoice Categorys for each client in order to know what they've done in the period after the selected category.

Example:

If I select month January and the category Home I am viewing this data.

2223	01.01.2014	January	Harry	Home
2225	20.01.2014	January	Paul	Home

In my chart I want to represent the following Invoice Categorys for each client:

2224	10.01.2014	January	Harry	School
2227	04.02.2014	February	Paul	Technology
2228	10.02.2014	February	Paul	School
2231	03.03.2014	March	Harry	Plants

The desired bar chart is this:

How can I achieve this?

Thanks in advance.

Kind Regards,

Luís

[#2]

Anyone to help?

[mrooney]

Hi

This is the expression you want:

=COUNT({$<Category =-{$(=Concat(Text(chr(34))&GetFieldSelections(Category,Chr(34)&','&chr(34),',')&Text(chr(34))))}>}Invoice)

Notice: Be aware there is a minus sign  after de equal.

Hope this help.

[ecolomer]

Here you have my proposal

[#5]

Hi Enrique

your solution does not meet our requirements

do you have another proposal?

thanks

[#6]

Hi Miguel,

your solution does not meet our requirements

do you have another proposal?

thanks