topic Re: requirement in QlikView

requirement

Anonymous — Wed, 14 Mar 2018 10:43:13 GMT

I have a requirement where I need to calculate sum(some field)

now I have two tables in my script(both having yearmonth flag),

sum(field) will be calculated when say yearmonth of table 1 is dec2017 den I need to take sum(field) where yearmonth in field2 shud be nov2017(I month befoe),

how I shud incorporate in set analysis

Re: requirement

bramkn — Wed, 14 Mar 2018 10:50:08 GMT

Your question is a bit confusing to me.

You have 2 tables with the same data?

is this field yearmonth qualified for the table it is in? or do you have a kalendar?

Re: requirement

Anonymous — Wed, 14 Mar 2018 11:03:17 GMT

data is different in both tables

Re: requirement

bramkn — Wed, 14 Mar 2018 11:05:13 GMT

sum({<yearmonthfield1={'dec2017'}>}field1)

sum({<yearmonthfield2={'nov2017'}>}field2)

Re: requirement

Anonymous — Wed, 14 Mar 2018 11:05:46 GMT

something like this:

sum({<yearmonth={'201712'},yearmonth2={'201711'}>}field)

Re: requirement

PrashantSangle — Wed, 14 Mar 2018 11:07:56 GMT

How do you load it ??

when concatenate it are you creating any flag??

try like

sum({<flag={'Table 1'},yearMonth={"$(=max(yearMonth))"}>}field)-

sum({<flag={'Table 2'},yearMonth={"$(=AddMonths(max(yearMonth),-1))"}>}field)

Regards,

Re: requirement

bramkn — Wed, 14 Mar 2018 11:07:57 GMT

with numbers you don't need the ''

if this is what you are looking for yes this should work. Without samples I can't help much more.