How to hide sensitive data from GL report

[paulyeo11]

Hi All

I have a GL exp table , it working fine.

GL_TABLE:
LOAD
'PMC' as SOURCE,
[Account Code] as AccountCode,
If([Account Code]>=8000000 and [Account Code]<=8900000,'EXP0') as [EXP0], //8008100 //SD SALARIES & ALLOWANCES
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date],
Remarks,
[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]);

For Each i in 108
WhatIfDimension$(i):
LOAD * INLINE [
Pls $(i)st Dim,Column$(i)
0_SOURCE,SOURCE
1_EXP LISTING,GL_DESC_
2_DRILL IN,Remarks,
3_YrMth,YearMonth
];
NEXT i;

Due to Salary amount is sentitive. i like to hide it. can some one share with how to do it ? and yet not affected the total expense amount.

Paul

[paulyeo11]

Hi All

Enclosed my QVW

Paul

[Arthur_Fong]

Try this:

GL_TABLE:
LOAD
'PMC' as SOURCE,
[Account Code] as AccountCode,
If([Account Code]>=8000000 and [Account Code]<=8900000,'EXP0') as [EXP0], //8008100 //SD SALARIES & ALLOWANCES
Date( Date#([Posting Date], 'DD.MM.YY'), 'DD/MM/YYYY') as [date],
Remarks,
[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]);

tempGL:
load
SOURCE,
AccountCode,
//EXP0,
date,
Remarks,
sum(Amount) as Amount,
GL_DESC_
resident
GL_TABLE
GROUP BY
SOURCE,
AccountCode,
//EXP0,
date,
Remarks,
GL_DESC_;

DROP TABLE GL_TABLE;
RENAME TABLE tempGL to GL_TABLE;

//continue with your for loop 

[paulyeo11]

Hi Sir

I think you must have mis-understanding what i trying to said. Base on the reading i think you try to delete the whole table , what i want is only remove some row of data at table , make is disappear. So it will still able to see the total expense amount. but unable to see the salary amount ?

Paul  

[Brett_Bleess]

Paul, check out the following, only way of which I can think you may be able to do things, the only other option that comes to mind is the OMIT feature in Section Access, but I figured you did not want to add Section Access to the app...

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/fi...

Regards,
Brett