Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am attaching both Sample QVW as well as sample excel file for my query which are in two parts.
1. My sample excel file is having different sheets with sheet name as Dec 16, Jan 17, Feb 17 and so on. But all the sheets have similar format data. I need a way to dynamically load all the sheets through one load statement. I think that it is possible but I am not aware of the process. My load statement for Dec 16 is as following :
LOAD [Mon-FY], Month as Mon, LEFT(FY,4) as Period, [GL Code], Description, [Field 1], [Field 2], [Field 3], [Field 4],
[Field 5]
FROM [Sample Excel File.xlsx]
(ooxml, embedded labels, table is [Dec 16], filters(Remove(Row, Pos(Top, 1)),Remove(Col, Pos(Top, 19)),Remove(Col, Pos(Top, 19))));
I need to load all other sheets data also through this load statement. Kindly suggest me if possible but without using ODBC.
2. I am trying to make a straight table chart but some error are there in my set analysis expression. I have made one set analysis expression for example purpose. And also I have made a text object to check whether I am doing right or wrong. There is error in my set analysis expression which I am not able to figure it out. My month selected is Jun but I want to make chart for May using variable vFirstPeriod which I have defined in an input box. Kindly Suggest me what wrong I am doing in my set analysis expression.
Regards,
Manish Prasad
Hi Prashant,
I have modified my qlikview document as per your suggestions but still there is problem. Can you attach my document after modifications as suggested by you so that I can re-check your app with that of mine as to what steps I am missing.
Regards,
Manish Prasad
Hi,
Please find attachment.
I did changes in script, chart and your Month List box
In Month List box use expression as Aggr(Mon,Mon)
Regards,
Prashant
Hi Prashant,
Thanks for your guide and suggestions. Now I have been able to accomplish my task.
Regards,
Manish Prasad