Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

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
Anil_Babu_Samineni

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

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
isingh30
Specialist
Specialist

Please share your data.

Thanks.

YoussefBelloum
Champion
Champion

Hi,

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

sunny_talwar

Souad - What is year of ligne?

YoussefBelloum
Champion
Champion

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

sunny_talwar

Make sense , year of which line?

YoussefBelloum
Champion
Champion

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

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

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂