topic Re: Pivot table prob in QlikView

Pivot table prob

nikhilgarg — Thu, 09 Apr 2015 10:52:56 GMT

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

Re: Pivot table prob

jpenuliar — Thu, 09 Apr 2015 11:07:03 GMT

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.

Re: Pivot table prob

nikhilgarg — Thu, 09 Apr 2015 11:17:45 GMT

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?

Re: Pivot table prob

awhitfield — Thu, 09 Apr 2015 11:21:27 GMT

Hi Nikhil,

you should raise this as a separate issue

Re: Pivot table prob

nikhilgarg — Thu, 09 Apr 2015 11:37:35 GMT

i ahve already raised much before but no one replied

Re: Pivot table prob

nikhilgarg — Thu, 09 Apr 2015 12:18:00 GMT

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

Re: Pivot table prob

awhitfield — Thu, 09 Apr 2015 13:03:28 GMT

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