Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

set analysis compraison

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

9 Replies

Re: set analysis compraison

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

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

Life is so rich, and we need to respect to the life !!!
isingh30
Contributor III

Re: set analysis compraison

Please share your data.

Thanks.

YoussefBelloum
Esteemed Contributor

Re: set analysis compraison

Hi,

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

Re: set analysis compraison

Souad - What is year of ligne?

YoussefBelloum
Esteemed Contributor

Re: set analysis compraison

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

Re: set analysis compraison

Make sense , year of which line?

YoussefBelloum
Esteemed Contributor

Re: set analysis compraison

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

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

Re: set analysis compraison

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

Re: set analysis compraison

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser