topic Re: Using Set Analysis with Text in QlikView

Using Set Analysis with Text

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to use below expression with set but somehow it is not working.

here i am trying to sum Headcount field value and i need to get the value for last month.

=sum({$<P_Month={"=Date(AddMonths(today(),-1),'MMMM')"}>}Headcount)

any help will be appreciated.

Regards

Sagar

MayilVahanan — Fri, 18 Aug 2017 10:01:06 GMT

Is it P_Month format correct?

Edit: Missed $ dollar.

=sum({$<MonthYear={"$(=Date(AddMonths(today(),-1),'MMM'))"}>}Headcount)

=sum({$<MonthYear={"$(=Month(AddMonths(today(),-1)))"}>}Headcount)

Chanty4u — Fri, 18 Aug 2017 10:02:55 GMT

Try:

=sum({$<P_Month={"$(=month(addmonths(today(),-1)),'MMMM')"}>}Headcount)

Anil_Babu_Samineni — Fri, 18 Aug 2017 10:25:31 GMT

Chanty,

How come Month() applies MMMM. Use Date()

neha_shirsath — Fri, 18 Aug 2017 10:25:57 GMT

What is the date format of P_month?

try this-

sum({$<[Month Name]={"$(=Monthname(addmonths(today(),-1)))"}>}Value)

sunny_talwar — Fri, 18 Aug 2017 12:21:15 GMT

May be this

=Sum({$<P_Month={"=Only({1}P_Month) = MonthStart(Today(),-1)"}>} Headcount)

=Sum({$<P_Month={"$(=Month(MonthStart(Today(),-1)))"}>} Headcount)

sagar_vij99 — Wed, 23 Aug 2017 07:39:52 GMT

Ohh yes i missed the $ sign,, Thanks for the reply.

Just for better understanding when we use formulas in set analysis then we have to use $ sign. What it actually indicates while execution..??

sunny_talwar — Wed, 23 Aug 2017 11:01:18 GMT

Check this link out