topic Re: Set analysis in QlikView

Set analysis

mario-sarkis — Tue, 07 Apr 2015 12:16:15 GMT

Hey All ,

i have a question wish any of you can help

Here is my example

I have list of Clients ID with there balances i want to find the diffrence between last two months of balances need to show it like this

[CliendID] [Balance last month] [Balance this Month] [Difference Balance Between this and Last Month]

how can i creat these fields in a straight table

help pleas Thank you,

Re: Set analysis

PrashantSangle — Tue, 07 Apr 2015 12:23:28 GMT

Hi,

Use Client ID as dimension,

Expression

1: Sum({<date={"$(=date(month(today())))"}>}[Balance])

2:Sum({<date={"$(=date(Addmonths(today(),-1)))"}>}[Balance])

3: Column(2) - Column(1)

Regards

Re: Set analysis

mario-sarkis — Tue, 07 Apr 2015 12:42:51 GMT

Hi Max

Thank you for Your reply

in my data base i have till a specific date it is not a daily update it

instead of today() i need use the maximum Date i have in a field and in a second field the maximum date minus one month (in order to see the balance in the last month).

how should i write it in a set analysis.

Thank you,

Re: Set analysis

PrashantSangle — Tue, 07 Apr 2015 12:48:50 GMT

Hi,

instead of today()

write max(date)

and if possible in script create MonthName from Date field

like monthName(Date) as Monthname

in expression

1: Sum({<MonthName={"$(=monthName(max(date)))"}>}[Balance])

2:Sum({<MonthName={"$(=MonthName(Addmonths(max(date),-1)))"}>}[Balance])

3: Column(2) - Column(1)

Regards