How to implementat my Qlik View Script work in Qlik Sense ?

[paulyeo11]

Hi All

I have below load script , it work fine for GL Table data analysis.

(A) Load GL Raw Data
GL_TABLE:
LOAD
'PMC' as SOURCE,
[Account Code] as AccountCode,
If([Account Code]>=5000000 and [Account Code]<=5999999,'P_Revenue') as [P_Revenue],
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date],
[Deb./Cred. (LC)] AS Amount,
[Account Name] AS GL_DESC_
FROM
[C:\Users\Paul Yeo\OneDrive - ISDN Holdings Limited\RAW DATA SAP\GL_PMC_2019.xlsx]
(ooxml, embedded labels, table is [Modified GL Data]);

(B) Create 1st Dimension for user to select what report they need to view.
For Each i in 108
WhatIfDimension$(i):
LOAD * INLINE [
Pls $(i)st Dim,Column$(i)
YrMth,YearMonth
DETAIL,GL_DESC_
SOURCE,SOURCE
];
NEXT i;

(C) Create the 2nd Dimension for user to select , for this case analysis on Revenue.
For Each i in 901,902
WhatIfDimension$(i):
LOAD * INLINE [
Pls select $(i)st Dim,Column$(i)
01 Revenue,P_Revenue
];
NEXT i;

Now it running fine at Qlik View. I need to implement in Qlik Sense. Can some one share with me.

As i enclunter issue :-
1) ColumnDim is not able to work in Qlik Sense.
2) I refuse to use extendsion because QVF is run in cloud.

Hope some one can advise me any work around ?

Paul Yeo

[paulyeo11]

Hi All

Enclosed my QVW file

Paul

[JordyWegman · Accepted solution]

Hi Paul,

Does this contain a fixed or variable amount of column names? Otherwise you can just put them in an inline table and request this in your column based on a variable. 

Jordy

Climber

[paulyeo11]

Hi Jo

Thank you very much for share with me using in line load .

my Field for table dimensions are YearMonth & SOURCE & GL_Desc. ( Don’t need in line load.

I have 2 GL expression :-

* YTD. amount
* LY amount

May I know in Qlik Sense how to insert above 2 expression ? And at the same time time allow insert all dimension ?

I have try pivot table is possible , but unable to insert YTD & LY expression.

Normal table allow me to insert YTD & LY expression , but not allow me insert more then 1 dimension.

Hope you can advise me.

Paul

[paulyeo11]

Hi Jo I have just try to using pivot table for my report , i am very surprise that i am able make it work as per my requirement. Now i understand by pivot table is very useful. Paul Yeo

[JordyWegman]

Hi Paul,

Good to hear, good luck with the application!

Jordy

Climber