Set analysis possible values

sibrulotte — Wed, 29 Mar 2017 21:49:21 GMT

Hi,

have a set analysis in which I thought would be simple that looks in accounting transactions:

sum({1< [Name]=p(Name), Financial_Year=p(Financial_Year), Financial_period = {'<=$(vPeriodefinanciere)'}>}(Amount))

I have a list box for Financial_Year and a list box for Financial_period (that triggers the variable vPeriodeFinanciere to be the possible value) .

So this works well without the "Name" set modifyer (ie: I get the whole year aka all the periodes below my chosen one), but alas, I want my user to be able to filter by name in this pivot chart.So I had to add the set modifyer Name = p(Name).

What happens in my pivot when I add that, is that I get only values that are possible in a selected period, plus all the values that are outside this period but only for the "Names" that exist in this period.

What am I not understanding about set analysis that I thought I understood for the past 2 years 😕

How do I get allll transactions and still let my user select a single "Name" if he wants.

Re: Set analysis possible values

tresB — Thu, 30 Mar 2017 05:09:01 GMT

Try like:

sum({1< [Name]=$::Name, Financial_Year=p(Financial_Year), Financial_period = {'<=$(vPeriodefinanciere)'}>}(Amount))

Re: Set analysis possible values

sibrulotte — Thu, 30 Mar 2017 13:55:53 GMT

That didn't realy work. When I select a Name that doesn't exist in the current period selected, all the selections go to scrap.

I think I need to review the idea of havina user be able to select a "Name"

topic Re: Set analysis possible values in QlikView

Set analysis possible values

Re: Set analysis possible values

Re: Set analysis possible values