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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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?