Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert excel formula into Qlikview expressions?

Guys,

Please help me on solving and having the exact report below:

Say that these my data

ITEM INQUIRY

MONTH YEARQTY
DEC-201156
JAN-201260
FEB-201230

BACKDATE QTY

MONTH YEARQTY
DEC-20116
JAN-20129
FEB-201215

THIS THE FORMAT/FORMULA EACH MONTH:


JAN-2012FEB-2012MAR-2012
BEGINNINGDec 2011 item inquiry + Dec 2011 back dateJan 2012 item inquiry + Jan 2012 back dateFeb 2012  item inquiry + Feb 2012 back date

RESULT:


JAN-2012FEB-2012MAR-2012
BEGINNING626945

I really don't know how to do that in set analysis or what should be the good thing to do.

Your help and suggestions are much appreciated.

Thanks,

Bill

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Dear Bill,

     You need to do some changes in data model.

     You need to link both the tables and then this will be easier for you.

     The script will look something like this.

     ITEM_INQUIRY:

     Load Month_Year,Qty as Item_Inquiry_Qty From ITEM_INQUIRY;

     BACKDATE:

     Load Month_Year,Qty as BACKDATE_Qty From BACKDATE;

     Here both the tables will link by Month_Year.

     Now all you need to do is create a chart with expression as

     sum(Item_Inquiry_Qty) + Sum( BACKDATE_Qty)

     Hope this is clear.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sushil353
Master II
Master II

Hi,

Please find the attached sample file for solution.

change the date format in the initial of script and then it will be easy to manupulate data in chart.

HTH

Sushil