Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

In pie chart , how to do a calculated dimention ?

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.

1 Solution

Accepted Solutions

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

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

2 Replies

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

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

Not applicable

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

Dear Anand , Thanks. I will try it.