Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
4 Replies
sameeramalik
Partner - Contributor
Partner - Contributor
Author

sameeramalik
Partner - Contributor
Partner - Contributor
Author

Please Reply

I am new to qlik

Anil_Babu_Samineni
MVP
MVP

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?