Section Acces and OMIT

DaanBrand — Wed, 25 Jul 2018 11:52:45 GMT

Hi all,

I have a question about the possibilty to combine Section Acces and Omit.

Please look at the data below:

ACCOUNT	EUR	KG
SU	10000	1000
AH	20000	2000
JU	30000	3000

I would like to have USER1 seeing all the data (EUR and KG) of ACCOUNT SU and only the KGs of all the other accounts.

If I use Seccion acces on ACCOUNT SU all data of AH and JU will be unvisible for USER1
If I use OMIT on field EUR the total EUR column will be unvisibile for USER1.

So I'm looking for a combinatie between those tho options.

The data has to be as follows:

ACCOUNT	EUR	KG
SU	10000	1000
AH		2000
JU		3000

Can anyone help me with this problem?

Thanks in advance..

Daan

Re: Section Acces and OMIT

YoussefBelloum — Wed, 25 Jul 2018 11:56:04 GMT

Hi,

I think you will need to make a crosstable using your existing table to transform your Currency type as a field..then you can use it as a reduction field

topic Section Acces and OMIT in QlikView

Section Acces and OMIT

Re: Section Acces and OMIT