topic Re: how to set a value list as a dimensional in script in QlikView

how to set a value list as a dimensional in script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi friends,

Alreday I have used the calculated dimensional in a bar chart by using value list method

=ValueList('Occupied','Partially Occupied','Available')

and expression is if(ValueList('Occupied','Partially Occupied','Available')='Occupied',vOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Partially Occupied',vPartiallyOccupied,if(ValueList('Occupied','Partially Occupied','Available')='Available',vAvailable)))

But i need to bring the calculated dimensional value list method =ValueList('Occupied','Partially Occupied','Available') in script wise as a dimensional

How can I bring the value list in script wise to set as dimensional

Regards,

Vijay.M

Re: how to set a value list as a dimensional in script

avinashelite — Mon, 03 Apr 2017 07:37:02 GMT

Simple create a inline table

LOAD *

[

Dim1

Occupied

Partially Occupied

Available

];

Re: how to set a value list as a dimensional in script

Anonymous — Mon, 03 Apr 2017 07:38:51 GMT

Why cant we use an inline table like

Load Status, <Your expression> as 'value' inline

[

Status

Occupied

Partially Occupied

Available

];

Re: how to set a value list as a dimensional in script

Anil_Babu_Samineni — Mon, 03 Apr 2017 07:41:21 GMT

Or it is easy to get

LOAD *

[

Parameters, SNO

Occupied, 1

Partially Occupied, 2

Available, 3

];

And then front-end should be

Dim as Parameters

and expression should this

if(sNO=1,vOccupied,if(SNO=2,vPartiallyOccupied,if(SNO=3,vAvailable)))