topic Re: set analysis compraison in QlikView

set analysis compraison

souadouert — Tue, 13 Feb 2018 14:31:17 GMT

i have straight table with date and client , ans i have this expression

sum({<MV={'L'},year ={'<=$(=(year ))'}>}TOTAL_N)

i need to sum TOTAL_N when year of date <= year of ligne

Anil_Babu_Samineni — Tue, 13 Feb 2018 14:33:07 GMT

date and year are which format? Perhaps this? If both are same format

sum({<MV={'L'},year ={"=date<=year"}>}TOTAL_N)

isingh30 — Tue, 13 Feb 2018 14:33:39 GMT

Please share your data.

Thanks.

YoussefBelloum — Tue, 13 Feb 2018 14:37:46 GMT

Hi,

you Mean Year of "selected" date <= Date of line ??

sunny_talwar — Tue, 13 Feb 2018 14:42:49 GMT

Souad - What is year of ligne?

YoussefBelloum — Tue, 13 Feb 2018 14:44:13 GMT

ligne (french) = line, so I think she talks about the year of the line

sunny_talwar — Tue, 13 Feb 2018 14:46:05 GMT

Make sense , year of which line?

YoussefBelloum — Tue, 13 Feb 2018 14:48:40 GMT

haha, she use date dimension on the table, so I think it is:

the Year of the Date of the lines of the table.

sunny_talwar — Tue, 13 Feb 2018 14:52:00 GMT

I still don't completely understand. May be provide some sample data Souad?

PrashantSangle — Tue, 13 Feb 2018 15:34:36 GMT

Year & Date are coming from same table or different??

is there any relation between both field

Please provide sample data and little bit more explanation which help us to provide more accurate solution.

Regards,