topic Re: Star is '*' not working in QEMC in QlikView

Star is '*' not working in QEMC

Anonymous — Sat, 11 Jul 2015 21:20:43 GMT

Can security be implemented in QEMC at Sheet Object Level?‌

this discussion has been moved to the above thread because the content is the same. Please follow discussion at the above link.

Thanks,

Re: Star is '*' not working in QEMC

swuehl — Sat, 11 Jul 2015 21:28:25 GMT

Could you detail a little more what exactely is not working? And it's not working on the server, but locally, or not working at all?

Re: Star is '*' not working in QEMC

Anonymous — Sat, 11 Jul 2015 22:25:03 GMT

As swuehl‌ said, no enough info. I can only give some explanation how the * works in section access. It doesn't mean "all values" - it means "all listed values". For example, you have this:

LOAD * INLINE [

ACCESS, USER, REDUCTIONFIELD

USER, USER1, A

USER, USER2, B

USER, USER3, C

USER, USER1, *

];

Here USER1 has access to REDUCTIONFIELD A,B, and C. If there are other values (e.g. D, E, F) - he doesn't have access to them. To get access to all values, it should be:

LOAD * INLINE [

ACCESS, USER, REDUCTIONFIELD

USER, USER1, A

USER, USER2, B

USER, USER3, C

USER, USER1,

];

Re: Star is '*' not working in QEMC

Anonymous — Sat, 11 Jul 2015 22:45:33 GMT

Below is my hidden script:

Section Access;

LOAD DISTINCT

Upper(ACCESS),

Upper(NTNAME) as NTNAME

FROM QMC;

Section Application;

Star is *;

SectionAccesstab:

LOAD Upper(NTNAME) as NTNAME,

Upper(ZONE) as %ZONE

From QMC;

The question: I have 10 charts and for 1 out of 10 charts, sales persons sud see data on all zones, for remaining charts and tabs across the dashboard, data sud be reduced zonewise. can we do it excel-free.

my approach: I am planning to control data reduction at expn level: For that one chart which sud allow data on all zone, I am not going to use, %zone in the expression of the chart. For all remaining charts, I am going to use %zone in the expn so that data is reduced according to definition. For eg. count(if(field1='13' and %zone=zone1,ID)) where zone1 is the actual fieldname in the app. this expn allows me to give respective sales person their zone-data. But the problem is for some users, when I assign " * " to give access to all data, chart is blank on front end when I use %zone=zone1 in the expn. however, the expn with %zone use is working correctly if a user is assigned a certain zone, just not for admins n users with a *.

what is your soln? cud there be a more robust approach?

Re: Star is '*' not working in QEMC

Anonymous — Sat, 11 Jul 2015 23:26:15 GMT

swuehl‌ and mov‌ any thoughts?

Re: Star is '*' not working in QEMC

Anonymous — Sun, 12 Jul 2015 00:20:36 GMT

How do I make QEMC understand that * means all listed values at expression level????????????

Re: Star is '*' not working in QEMC

swuehl — Sun, 12 Jul 2015 08:56:28 GMT

As I posted to you other thread (please try to avoid re-posting), I believe the star symbol * semantic for 'all listed values' is only valid within section access, not section application tables.

Try

=count( if( field1='13' and ZONE LIKE %ZONE, ID))