Pivot table prob

[nikhilgarg]

Hey,

In my attached qvw , i have a pivot table with Pivot table caption. Now when i am selection desk d20 then , DeskName an dSalesperson name is hidden. Can anyone tell em why is it so and what to do it to show it??

Thanks

[jpenuliar · Accepted solution]

Hi Nikhil,

Move the logic in your pivot calculated dimension (=if(len(SalesRegion)=0 , 'Unknown' , SalesRegion) ) to Script side.

In the Table below, actual value is null for d20.

[nikhilgarg]

Thanx it helps

Can you help me regarding my other prob?

I have one dashboard in Dev server and QA server. My dev server dashboard reloads everyday but QA server dashboard doesnot reload everyday. I want it to reload everyday. What to do for this?

[awhitfield]

Hi Nikhil,

you should raise this as a separate issue

[nikhilgarg]

i ahve already raised much before but no one replied

[nikhilgarg]

Hey,

Thankx. Let say i have server named as :

DEV and QA

I access DEV QMC as:                 DEV:4780/qmc  ->  QMC opens

Similarly, i tried for QA server as:   QA:4780/qmc    ->   I get error that:  Membership of local security group is missing.

Am i accessing QA server in ryt manner? Does QA QMC accessed in same manner as DEV ??

Thanks

[awhitfield]

In that case, your user is not a member of the Qlikview Administrators Group on the QA server.