Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

Security Access Right Hide Change Field Values.

HI,

Very Urgent.

This is the Table i have.

TransactionCode

CompanyCountrySalesAmount
01BMWGERMANY50000
02BMWGERMANY60000
03BMWGERMANY90000
04VOLKSWAGENGERMANY50000
05MERCEDESGERMANY100000
06PORSCHEGERMANY150000
07FORDUSA90000
08FORDUSA80000
09CHEVROLETUSA30000
10RENAULTFRANCE20000
11RENAULTFRANCE30000
12CITROENFRANCE40000
13PEUGEOTFRANCE10000

When i Access my app with BMWuser, i want to See:

Table:

CompanyCountrySalesAmount
BMWGERMANY200000
Germany Car 1GERMANY50000
Germany Car 2GERMANY100000
Germany Car 3GERMANY150000
USA Car 1USA90000
USA Car 2USA80000
USA Car 3USA30000
France Car 1FRANCE20000
France Car 2FRANCE30000
France Car 3FRANCE40000
France Car 4FRANCE10000

KPI's:

BMW sale amount = 200000

Total Germany Car sales = 50000 + 100000 + 1500000 = 300000

BMW sales / Total Germany Car sales : 200000 / 300000 =  66 %

Total Sales Of All Company in ALL Countries = 800000

BMW sales / Total Sales Of All Company in ALL Countries : 200000 / 800000 = 25 %


Thanks in advance.

2 Replies

Re: Security Access Right Hide Change Field Values.

Check if that helps? You can create KPI's based on my table?

Update - Check with KPI's as well.

Capture.PNGCapture.PNG

Sections Access Script

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Security Access Right Hide Change Field Values.

Did you get a chance to look?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)