Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

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

View solution in original post

2 Replies
its_anandrjs

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
Author

Dear Anand , Thanks. I will try it.