topic Re: Help in Creating List box/buttons based on the calculated columns of pivot table in QlikView

Help in Creating List box/buttons based on the calculated columns of pivot table

Mon, 17 Feb 2014 12:51:06 GMT

Hello ,

Would really appreciate your help on my below concern

I have created a pivot table with a few calculated columns and have renamed those columns according to the requirement.
Now i need to create a list box or relevant object which should be capable of holding all those renamed columns as multiple selection buttons

To explain more on that

i have server models a,b,c,d ... as my dimentions and i have Memory , processors , harddrives , controllers on the columns which are calculated columns ...

now i need to have Memory , Processor harddrives as seperate objects outside the table so that i can select which ever i want only to be shown

can you help here please ??

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

hic — Mon, 17 Feb 2014 13:13:50 GMT

It sounds as if all these fields have static definitions, i.e. they don't change when a user makes a selection. Then I would create these fields in the script, so that the same definition can be used both for a list box and for a chart dimension .

HIC

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Mon, 17 Feb 2014 13:29:44 GMT

hi, Ravi Kiran

Can u provide Example Data/qvw for Better Understanding

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Mon, 17 Feb 2014 13:49:15 GMT

Can you please help me understand how you create that in the script?

the above mentioned is my pivot table

all the columns mentioned are calculated columns

is there a way i create a list box with these columns in it so that which ever metric/metrics i select - only those should be visible

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

hic — Mon, 17 Feb 2014 14:08:22 GMT

It depends on how your script looks. Which fields and tables do you have?

HIC

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 05:56:16 GMT

Hello,

This is my script

AttachWW:

LOAD [Form Factor_Attach],

[Server Model_Attach],

Gen_Attach,

[Processor Count_Attach],

[Date Code_Attach],

Country_Attach,

Region_Attach,

[NetRev Server_only_Attach],

[NetRev Blade_Specific_Options_Attach],

[NetRev BT_Others_Attach],

[NetRev Controllers_Attach],

[NetRev ENCL_Attach],

[NetRev Hard_Drives_Attach],

[NetRev Memory_Attach],

[NetRev NICs_Attach],

[NetRev Optioned_Up_Attach],

[NetRev Processors_Attach],

[NetRev RPS_UPS_Attach],

[NetRev Software_Attach],

[Units Server_only_Attach],

[Units Blade_Specific_Options_Attach],

[Units BT_Others_Attach],

[Units Controllers_Attach],

[Units ENCL_Attach],

[Units Hard_Drives_Attach],

[Units Memory_Attach],

[Units NICs_Attach],

[Units Optioned_Up_Attach],

[Units Processors_Attach],

[Units RPS_UPS_Attach],

[Units Software_Attach]

FROM

(qvd);

There is only one table used and the fields are as mentioned above . is this information sufficient ?

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

hic — Tue, 18 Feb 2014 07:08:28 GMT

It is still unclear. Example: You say you want "Memory" in a separate list box. But in your Load statement, you have both [NetRev Memory_Attach] and [Units Memory_Attach] as fields. Do you want to merge these? If you do, then you should most likely load your data in a different way.

So, please post a qvw file.

HIC

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:21:08 GMT

Hi Henric,

I am unable to post a QVW file , is there a specific location to post it ?? m new to this community and would kindly request you to help me here

Thanks

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Anonymous — Tue, 18 Feb 2014 07:29:41 GMT

Hi Ravi,

use advanced editor in the post QVW,when you try to add a reply there is 'Use advanced editor' link on top corner.

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:29:59 GMT

please see

please have look at images

this will help you how to attach qvw or any file to community

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:41:31 GMT

Below mentioned snapshot is what i get when i click on reply

I dont get to see any attach / advanced filter option ..;. how do i go about getting it ??

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

kiranmanoharrode — Tue, 18 Feb 2014 07:42:16 GMT

Dear Ravi,

I think you have to show only those calculated dimension which are selected in list box. so as per my understanding solution will be

Create Inline table which wont linked to your data model.

it will include 4 records as your dimension. Memory , processors , harddrives , controllers. Give field name as per your requirement. for ex. Dimension will be your field name. and it will include 4 records.

2. Now Enable condition for the calculated dimensions.

for example we want report as per Memory and Controllers

Condition for Calculated Dimension Memory will be:

if(GetSelectedCount(Dimension)>0 and wildmatch(Concat(DISTINCT Dimension,','),'Memory'),1,0)

Condition for Calculated Dimension Controllerswill be:

if(GetSelectedCount(Dimension)>0 and wildmatch(Concat(DISTINCT Dimension,','),'Controllers'),1,0)

Create condition for your all dimensions.

and Include inline field Dimension in list box and enable check box in for multiple selection

I hope it will be help you.

Regards

Kiran Rode

+91 8976977897

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Anonymous — Tue, 18 Feb 2014 07:43:23 GMT

Please Save this dialog with some text and try to edit,you may see the use advanded editor or attach link then

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:46:18 GMT

dfgsDFsdfDFSDFDfsdfasdf

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:46:45 GMT

Oops , m sorry , it was a typo

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 07:50:30 GMT

in your inbox click see following image and click on that in your inbox then you can attch qvw files

Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 08:49:44 GMT

Hi ,

Finally could attach the QVW.

Could you please help in getting conditional hide /show columns which has expressions based on the selection

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 09:06:01 GMT

Hi ,

I have attached the QVW now.

Can you please look through this and help me out

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

hic — Tue, 18 Feb 2014 09:41:29 GMT

What do you want to have in your Memory list box? Numbers like below?

Further, your data model seems incomplete. Should there not be a link between Basctry and AttachWW?

HIC

Re: Re: Help in Creating List box/buttons based on the calculated columns of pivot table

Tue, 18 Feb 2014 10:11:23 GMT

Hi Henric ,

Memory is a calculated column like below

=if(V_Attach=0,(Sum([Units Memory_Attach]))/(Sum([Units Server_only_Attach])),(Sum([NetRev Memory_Attach]))/(Sum([NetRev Server_only_Attach])))

where V_Attach is a variable used like a toggle switch , when U:U is selected in my qvw , it should perform first half of the calculation else when $:$ is selected the second half calculation should be displayed

the data model is like that , BASCTRY and ATTACH are two different things and hence no relation