Discussion Board for collaboration related to Creating Analytics for QlikView.
I have got a problem. I have a section access and 2 sheets.
My section access :
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA
USER, USER2, U2, AMERICA
USER, USER3, U3, ASIA
USER, USER4, U4, EUROPE
USER, USER5, U4, AMERICA
USER, USER5, U5, *
In my sheet 1, USERS can see only data from their Region.
And in my Sheet 2 (only 2 charts), I want that my USERS see all data ALL REGION. Just for a data comparaison.
Is it possible to unhide the data just for one sheet ?
Thanks a lot
I think you could load all regions separately aggregated:
'ALL REGION' as REGION,
Sum(PROFIT) as TotalProfit
GROUP BY 'ALL REGION';
And then use 'ALL REGION' in section access.
Like this ?
ACCESS, USERID, PASSWORD, REGION, ALL REGION
USER, USER1, U1, AFRICA, YES
USER, USER2, U2, AMERICA, YES
USER, USER3, U3, ASIA, YES
USER, USER4, U4, EUROPE, YES
USER, USER5, U4, AMERICA, YES
USER, USER5, U5, *, YES
As you can see I've loaded the value 'ALL REGION' in field named REGION, so no, not like this.
Ok thanks I wil try your method !