topic help in calculation in QlikView

help in calculation

ali_hijazi — Mon, 15 Aug 2016 10:28:00 GMT

Hello

I got a pivot table by Month Year

the user selects Jan 2016

and I want to count the number of customers that had only invoice transactions in Feb 2015

is this possible?

Feb 2015 is calculated from Jan 2016 i.e. it is the date 11 months prior to Jan 2016

please advise

Anonymous — Mon, 15 Aug 2016 10:40:51 GMT

use set analysis

Count{<MonthYear={$(=addmonths(MonthYear,-11)}>}Value

it maybe that you Need to Format the dateformat using date(=addmonths(MonthYear,-11,'YYYYMM')

ali_hijazi — Mon, 15 Aug 2016 10:43:25 GMT

and is it possible to list them instead of counting them

I mean next to Jan 2016 display the names of the customers who got invoiced only in Feb 2015

Anonymous — Mon, 15 Aug 2016 11:01:25 GMT

Not tested ..

may be like this ?

Assuming your field is Customername

Only({$<MonthYear={$(=addmonths(MonthYear,-11)}>} Customername)

=Concat({$<MonthYear={$(=addmonths(MonthYear,-11)}>>} DISTINCT Customername, ', '))