topic Data reduction in QlikView in QlikView

Data reduction in QlikView

udaya_kumar — Thu, 30 Nov 2017 12:19:54 GMT

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.

Re: Data reduction in QlikView

zhadrakas — Thu, 30 Nov 2017 12:28:35 GMT

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

Re: Data reduction in QlikView

avinashelite — Thu, 30 Nov 2017 12:36:02 GMT

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

LOAD

ACCESS,

USERLIST2 as NTNAME,

' USER2_LIST' as Flag

from

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