Discussion Board for collaboration on QlikView Scripting.
The requirement is USER1
The code I have written for this is as follows
SECTION ACCESS; LOAD * INLINE [ ACCESS,USERID,CALENDAR YEAR,CALENDAR MONTH ADMIN,ADMIN,,, USER,USER1,2011,03 USER,USER1,2012, ];
But it is showing only 3rd month for year 2012.
The solution for this problem is to create a DUMMY user and put * against USER1 as follows
SECTION ACCESS; LOAD * INLINE [ ACCESS,USERID,CALENDAR YEAR,CALENDAR MONTH ADMIN,ADMIN,,, USER,USER1,2011,03 USER,USER1,2012,*
Need to find out the workaround for this problem as this approach is not feasible
if you you want to show all data then leave blank in section access fields.give value for them who want to see selected data.
ACCESS,USERID,CALENDAR YEAR,CALENDAR MONTH
if you will give * (then you have to put all value in in field(dummy)) because * means -only that data which is available in section access field.
if you will give
CALENDAR YEAR,CALENDAR MONTH
now you will use * means only u can see 2,3
if you leave it blank then you will see all data available in field.
The problem is that it's not understanding you want a relationship between year and month, so it's simply restricting month to the value you dictate unless it knows there are other values available.
The best way I can think to do this is to create a group or flag in your script. Attach this in your model to your date field, and then in your section access restrict on the group.
For (a rough) example:
If(Year=2011 and Month=3, 1, 0)) as GROUP
Then in your section access, use GROUP as your restrict field and 1 as the value to restrict on.
thanks for help but is there any other way???