Data reduction in QlikView

[udaya_kumar]

Hi,

I have the data till date in the dashboard.

I have two types of users, say UserSet1 and UserSet2.

I have to show the data till date for UserSet1 and the data till previous month for the UserSet2.

How is it possible to implement this requirement in QlikView?

Can someone please help me?
Thanks in advance.

[zhadrakas]

Hello Uday,

in this case i would create a master calender and create a flag on script Level for UserPermissions

Maybe like this

Permissions

UserSet1

UserSet2

based on this you can create a section Access Table

Permissions:

load * inline [

NTNAME,      Permissions

ADMIN,       *

User1,       UserSet1

User2,       UserSet2

];

regdards

tim

[avinashelite]

it should the combination of Section access and then a flag to show the data sets ....

Flag logic in your Data set

SECTION ACCESS;

LOAD

ACCESS,

USERLIST1 as NTNAME,

' USER1_LIST' as Flag

from

t;

LOAD

ACCESS,

USERLIST2 as NTNAME,

' USER2_LIST' as Flag

from

t;

Section Application;

LOAD USERLIST1

from

table ;

LOAD USERLIST2

from

table ;

Main_Table:

LOAD *,

if( Exists(USERLIST1,USER),'USER1_LIST',

if( Exists(USERLIST2,USER),'USER2_LIST')) as Flag

hope this helps