topic Re: Prob in pivot table in QlikView

Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 09:30:23 GMT

Hey,

In my attached application, for unknown region in pivot table there are shown 4 Names but when i select Desk as Unknown from list box it is showing only 2 names. Pls help.

Thanks

Re: Prob in pivot table

buzzy996 — Thu, 09 Apr 2015 09:34:45 GMT

tht's because of ur expression defined like this =if(len(Desk) = 0 , 'Unknown' , Desk)

NAME: Y & U having null values tht's lenth it's assuming as 0 so u have 4 in desk (y,u,a,c)

Re: Prob in pivot table

pokassov — Thu, 09 Apr 2015 09:39:34 GMT

Hi!

It's because you use dimention expression instead of "Desc"

=if(len(Desk) = 0 , 'Unknown' , Desk)

Re: Prob in pivot table

massimilianoruf — Thu, 09 Apr 2015 09:40:09 GMT

Hi Nikhil,

this happens because the Dimension of the table is a Calculated Dimension and the values linked to "Unknown" are only "a" and "c".

Massimiliano

Re: Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 09:45:18 GMT

So , what to do because when i click Unknown it should show Y and /U also

Re: Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 09:46:00 GMT

So , what to do because when i click Unknown it should show Y and /U also

Re: Prob in pivot table

massimilianoruf — Thu, 09 Apr 2015 09:51:44 GMT

You should modify the load script for delete null Desk values.

Load

...

if(IsNull(Desk),'Unknown',Desk) as Desk,

...

Hope this helps,

Massimiliano

Re: Prob in pivot table

jonathandienst — Thu, 09 Apr 2015 09:56:07 GMT

Then I suggest that you convert the nulls to 'Unknown' in the load script:

LOAD

....

If(Len(Desk) = 0, 'Unknown', Desk) As Desk,

HTH

Jonathan

Re: Prob in pivot table

buzzy996 — Thu, 09 Apr 2015 10:02:39 GMT

i think ur using mapping in script, so pls try this..

Mapping LOAD isnull(Name,'Unknown', Name) as Name

Re: Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 10:54:04 GMT

Hey,

THankx but i didn't get you. i am already using script that you suggesting

Re: Prob in pivot table

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

Can you plz elaborate.

Thanks

Re: Prob in pivot table

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

do you mean to say that:

Table1:

Mapping Load

Name,

isnull(Desk,'Unknown', Desk) as Desk

Is it you mean?

Re: Prob in pivot table

buzzy996 — Thu, 09 Apr 2015 11:04:23 GMT

just replace this code in ur Main 4 tab with table2,

Table2:

Mapping LOAD isnull(Name,'Unknown', Name) as Name,

Desk

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 11:16:00 GMT

Thankx buddy, it helps. I just needed to shift my calculated dimension code to script side

Re: Prob in pivot table

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

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: Prob in pivot table

buzzy996 — Thu, 09 Apr 2015 11:32:16 GMT

if I'm not understand wrongly,u can schedule ur dashboard on ur QA Server.

Re: Prob in pivot table

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

Can you tell me how?

Becoz in DEV server , i see in QMC, there is specified the reload time for

evryday and at that time dashboard is being reload on DEV server. Does QMC

reload setting is different for QA server? Do i need to check QMC setting

in QA also ?

Re: Prob in pivot table

buzzy996 — Thu, 09 Apr 2015 12:08:47 GMT

yes, first u have to confirm the application is deployed on network drives and configured accordingly the setting in ur both the servers or not?

if ur application is placed in ur local box then the setting will be different on both the server's.

Re: Prob in pivot table

nikhilgarg — Thu, 09 Apr 2015 14:26:44 GMT

Ohk but i just want to confirm that am i using correct way to access QMC on QA ?

QAServername:4780/QMC ?

Thanks