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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksus
Specialist II
Specialist II

Regarding MTD calculation

Hi,

Iam posted a Qvw file with Excel data.

just open the qvw you will find 2 chart and 2 text object. Now my problem is that when i select 10/10/2009 then for CURRENT RATEOFSALE IS RATEOFSALE OF '10/10/2009' AND MTD RATEOFSALE is cumulative of RATEOFSALE ('10/01/2009' TO '10/10/2009') . BUT THE CURRENTSALE TEXT OBJECT is giving the Cumulative rateOfSale (23.7) which is eqaul to CURRENT SALE CHART. But the MTD TEXT OBJECT IS GIVING ME OUTPUT AS 23.7 WHICH IS NOT SAME WITH MTD CHART. CAN ANYONE HELP ME HOW TO GET MTD CHART RATEOFSALE OUTPUT(i.e 94.2) in MTD TEXT OBJECT.

Waiting for reply?????????

0 Replies