topic Re: Dimension in ValueList in QlikView

Dimension in ValueList

Fri, 16 Oct 2015 21:49:17 GMT

How can we add Dimesions in Valuelist?

robert_mika — Fri, 16 Oct 2015 23:02:11 GMT

You can not.

Valuelist can only take static values.

settu_periasamy — Sat, 17 Oct 2015 03:31:37 GMT

Hi,

Do you mean Dimension values in Valuelist?

You can create a variable, and you can use that in your Dimension.

Check, if this suits for you

vCheck : =Concat(DISTINCT chr(39)&Dim1&chr(39),',')

Dimension : =ValueList($(vCheck))

Expression :

=Pick(Match(ValueList($(vCheck)),$(vCheck)),sum({<Dim1={A}>}Sales),
sum({<Dim1={B}>}Sales),sum({<Dim1={C}>}Sales),sum({<Dim1={D}>}Sales))

refer the attachment

CELAMBARASAN — Sat, 17 Oct 2015 17:14:23 GMT

Hi,

Instead adding dimension field to Value list, add the values to the dimension within the Load script. So that you can simply use

if(field='value1', Expr1,//for value list texts

if(field='value2', Expr2,//for value list texts

Expr3))//for dimension values

Mon, 19 Oct 2015 16:58:56 GMT

Thank you for the reply.

Here my problem is little different, I want to add Total row in Bar Chart. So "Total" should be added to the dimension list.

Could you suggest any workaround?

petter — Mon, 19 Oct 2015 17:17:03 GMT

You can certainly use settu_periasamy's suggestion but appending the TOTAL to the list :

vCheck : =Concat(DISTINCT chr(39) & Dim1 & chr(39) , ',' ) & ', ''TOTAL'' '

Dimension : =ValueList( $(vCheck) )

Or you might be better off making the appending in the load script by just adding the extra TOTAL value there.

Mon, 19 Oct 2015 21:01:21 GMT

Thank you. I choose 2nd option. because it is not required to define different expressions for each dimension value.