topic Re: Dynamic dimension values in QlikView

Dynamic dimension values

Fri, 30 Nov 2012 14:01:48 GMT

Hi,

I have a pivot table with 4 dimensions. One of the dimension is "Summary Label1" with values as below -

PRIORITY

REVENUE (Current YTD)

REVENUE (FY 12)

CREDIT EXPOSURE

PRODUCT COUNT

CALLING

ROE

I want to ignore ROE for certain users so that that column will not be displayed in pivot. Is there a way to dynamically ignore "Summary Label1" dimension values based on some condition? (I have a condition that determines which users should see ROE)

I am using section access for different purpose so dont want to introduce above layer in there... Also, I dont want to create another dimension specifically for this purpose as my chart expressions are based on conditions using "Summary Label1" so creating another dimension may lead to maintain seperate copy of the table..

Appreciate if someone can suggest any options...

Thanks in advance!

Re: Dynamic dimension values

MayilVahanan — Fri, 30 Nov 2012 14:50:09 GMT

May be try like this

=if(QvUser() = 'UserName', Sum({<Summary Label1-={'ROE'}>}Sales),Sum(Sales))

Morethan one user want to ignore, use match() function instead of if()

Here QVUser() gives name of the current QlikView user as entered in a section access. For him, we can restrict the particular value..

Note:

-= shows error in expression box, but its bug. so pls ignore that

Hope it helps

Re: Dynamic dimension values

Mon, 03 Dec 2012 13:22:28 GMT

mayil, thank for deplying..

my expression is pretty big with if else conditions to calculate different value for each of the dimension value. as such i have only one expression. i had to follow this route as our users wanted a pivot with multiline headers..

even if i ignore calculating ROE formula in my expression, the column is still visible with - for all rows.

My requirement is to hide ROE column completely for certain users..

Re: Dynamic dimension values

Mon, 03 Dec 2012 17:06:22 GMT

Which Version of QlikView are you using? I believe that version 11 has the ability to "Enable Conditional" statements for Dimensions and Expressions.