Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
kaushik_solanki
Not applicable

Re: How to convert excel formula into Qlikview expressions?

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

sushil353
Not applicable

Re: How to convert excel formula into Qlikview expressions?

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