Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
sameeramalik
Partner - Contributor
Partner - Contributor

MTD Logic Problem

Hi all,

This expression is working fine for MTD Logic

Sum({<Date_Comm=,FY_Date_Num={">=$(=Num(MonthStart(Max(FY_Date_Num))))<=$(=Max(FY_Date_Num))"}>} Bud_Sales)

Example: Date_Comm  is dimention

On selecting Date_Comm feild the above expression gives the correct output.

Daily= 0.2

MTD= 0.41

On contrary, applying = Date_Comm as selection the output is

Daily= 0.2

MTD= 0.2

I suppose bypass is not working when we add = sign to selected dimention ( eg : = Date_Comm ) filter.

We need to add  = sign with the calender extension.

Kindly provide solution on the above problem

Please find below attachment

4 Replies
sameeramalik
Partner - Contributor
Partner - Contributor
Author

sameeramalik
Partner - Contributor
Partner - Contributor
Author

Please Reply

I am new to qlik

Anil_Babu_Samineni

This is weird behavior, Can you attach your QVF file

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
neelamsaroha157
Specialist II
Specialist II

Can you share a sample file?