topic Re: Dynamic Selection of Field in listboxes in QlikView

Dynamic Selection of Field in listboxes

Mon, 25 Feb 2013 20:21:17 GMT

Hai,

I am attaching a file , I have created two groups and list boxes with those two groups,

Group1

categoryname

companyname

Firstname// Employeename

group2

Sum(extendeprice) //sum(sales)

sum(quantity)

now I want the chart to display the data year wise , when I select categoryname and sum of quantity,

categoryname and sum of sales.

similarly companyname and sum of quantity

...

so when I select any of those fields, the data should be displayed in Pie chart,

Please can anyone have the idea to solve this problem

Regards,

Ramesh

Re: Dynamic Selection of Field in listboxes

MayilVahanan — Mon, 25 Feb 2013 22:04:17 GMT

PFA

Re: Dynamic Selection of Field in listboxes

Mon, 25 Feb 2013 22:06:53 GMT

You don't need variables with a pick/match functions since the values of Group1 and Group2 contain the field names and expressions, respectively. Just use $(=Group1) as your dimension and $(=Group2) as your expression.