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

Dimension Help

Hi Friends,

I want to create a dimension in coding or pie chart in design using below measures. Is there any way to do that. please help. Thanks

PAR 7 =sum(If(ArrearsRentals>0,(CapitalArrears/ArrearsRentals),0))

PAR 14 =Sum(If(ArrearsRentals>1,(CapitalArrears/ArrearsRentals),0))

PAR 30 =Sum(If(ArrearsRentals=3,(CapitalArrears/ArrearsRentals),If(ArrearsRentals>3,(CapitalArrears/ArrearsRentals)*2,0)))

PAR 60 =Sum(If(ArrearsRentals=5,(CapitalArrears/ArrearsRentals), If(ArrearsRentals=6,(CapitalArrears/ArrearsRentals)*2,                If(ArrearsRentals=7,(CapitalArrears/ArrearsRentals)*3, If(ArrearsRentals>7,(CapitalArrears/ArrearsRentals)*4,0)))))

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

You can use ValueList() Function like this

Dimension : =ValueList('PAR7','PAR14','PAR30')

Expression :

Pick(Match(ValueList('PAR7','PAR14','PAR30'),'PAR7','PAR14','PAR30'),sum(If(ArrearsRentals>0,(CapitalArrears/ArrearsRentals),0)),Sum(If(ArrearsRentals>1,(CapitalArrears/ArrearsRentals),0)),
Sum(If(ArrearsRentals=3,(CapitalArrears/ArrearsRentals),If(ArrearsRentals>3,(CapitalArrears/ArrearsRentals)*2,0))))

Regards,

Antonio

View solution in original post

9 Replies
dberkesacn
Partner - Creator III
Partner - Creator III

Hi,

You can make calculated dimension, in the expression editor you can us lot of function AGGR, IF ... for making custom dimension.

agigliotti
Partner - Champion
Partner - Champion

yes each PAR become one calculated dimension on chart object.

Not applicable
Author

Thanks daniel and Andrea, But I want to add all PARs into one dimention. Can I do that?

dberkesacn
Partner - Creator III
Partner - Creator III

Could you show some mock up, which describes the result?

Not applicable
Author

As an example, In a pie chart, I want to show the contribution of PARs(Percentages). so there are PAR 7, PAR 14, PAR 30 and PAR 60. I want to show them in an one pie chart. I have attached an excel data sheet for relevant data. Thanks !

Not applicable
Author

Hi, can anyone help me with this?

antoniotiman
Master III
Master III

Hi,

You can use ValueList() Function like this

Dimension : =ValueList('PAR7','PAR14','PAR30')

Expression :

Pick(Match(ValueList('PAR7','PAR14','PAR30'),'PAR7','PAR14','PAR30'),sum(If(ArrearsRentals>0,(CapitalArrears/ArrearsRentals),0)),Sum(If(ArrearsRentals>1,(CapitalArrears/ArrearsRentals),0)),
Sum(If(ArrearsRentals=3,(CapitalArrears/ArrearsRentals),If(ArrearsRentals>3,(CapitalArrears/ArrearsRentals)*2,0))))

Regards,

Antonio

Not applicable
Author

Thanks Anatonio for your great help.

Not applicable
Author

Hi , can I create this dimension in the coding part as PAR?