topic Re: Problem with value list? in QlikView

Problem with value list?

pgrs4219 — Sun, 05 Feb 2017 05:53:03 GMT

Hi Community,

I have a requirement that i need to visualize my data points exactly like the way i have shown in following spread sheet.Here i am using value list to create dummy dimensions with three value valuelist('value1','value2','value3') and i have two expressions.for first expression i want to show the three value value1,value2,value3 but in second expression i only need to values value1 ,value3 to meet my requirement .again if am doing above procedure am geeting 3 values for second expreesion though i didn't not mention it in expression,because its valuelist.So is there any workaround in order to acheive same kind of view as i have in below spread sheet.Kindly help me. Thanks

Re: Problem with value list?

vinieme12 — Sun, 05 Feb 2017 06:06:54 GMT

can you post some sample data?

Re: Problem with value list?

ahaahaaha — Sun, 05 Feb 2017 09:06:15 GMT

Hi,

Vineeth rights, from ValueList.xls is not very clear idea. Maybe these considerations will help.

In the file qvw there is no data, the database is empty. Constract Chats with valuelist().

1) Calculation of third degree values of synthetic dimension (all values)

Dimensions: =ValueList(1,3,5)

Expression: pow(ValueList(1,3,5), 3)

Result

2) Calculation of only specific values for synthetic dimension (only the values indicated in the expression)

Dimensions: =ValueList(1,3,5)

Expression:

If(ValueList(1,3,5) = 1, 1,

If(ValueList(1,3,5) = 5, 125,

))

Result

Maybe your case is described in option 1) and option 2) you need?

Regards,

Andrey

Re: Problem with value list?

MarcoWedel — Sun, 05 Feb 2017 17:56:58 GMT

please post a sample that includes data for all source fields and your expected result.

thanks

regards

Marco

Re: Problem with value list?

sunny_talwar — Sun, 05 Feb 2017 20:35:45 GMT

Marco, I think its a triple post.... qvw sample here:

Customized Value List