Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Issue in calculating monthly trend from accumulated field

Hello Everyone,

I want monthly trend of Apr-Mar of a particular field i.e, (NEP+TP_NEP).

I am using below mentioned expression for the same :

=if(WildMatch(Month,'Apr'),(sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP)),

            ((sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP))-

                Above((sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}NEP)+sum({<Freeze_Date={">=$(vYTDStart)<=$(vYTDEnd)"}, FiscalYearDesc=, Month=>}TP_NEP)))))/10000000

But with this expression I am not getting value for the month of Apr.

Requesting you to guide me to get proper output from Apr to Mar.

Eg:

Actual data

Month     NEP

Apr         100

May        120

Jun         180

Jul           200

O/P required:

Month     NEP

Apr          100

May         20(May-Apr)

Jun          60(Jun-May)

Jul          20 (Jul-Jun)

so on and so forth..

Thank you in advance...

hicgwassenaarjagan‌ Please help !!!

Regards,

Sarfaraz Sheikh

2 Replies
Anil_Babu_Samineni

Try to share the Sample

Or else PFA

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)
sunny_talwar

I think as Anil pointed out, we will be able to help better if you can provide the sample application.

Preparing examples for Upload - Reduction and Data Scrambling