topic In pie chart , how to do a calculated dimention ? in QlikView

In pie chart , how to do a calculated dimention ?

Sun, 07 Dec 2014 10:33:22 GMT

Dear sirs , in pie chart , how to do a calculated dimention from a certain field to pick several field value , and , how is the relative expressions. For example , I have 2 fields , category & amt. I want to show ca1 , ca2 for dimention , and , sum relative amt in expressions. Please help.

Re: In pie chart , how to do a calculated dimention ?

its_anandrjs — Sun, 07 Dec 2014 10:41:00 GMT

Hi,

Assume this example with two fields

LOAD * Inline [

category , amt

ca1,10

ca2,20

ca3,30

ca4,24 ];

1. First way is

Dim:- =if(Match(category,'ca1','ca2'),category)

Expre:- sum(amt)

2. Second Way is

Dim:- category//Without calculated dim

Expre:- sum({<category={'ca1','ca2'}>}amt) //With SET analysis expression

Regards

Anand

Re: In pie chart , how to do a calculated dimention ?

Sun, 07 Dec 2014 11:13:07 GMT

Dear Anand , Thanks. I will try it.