Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Calculate Growth

Hi,

I want to create a D-growth chart.

It means, If my target value is 10 and sales is 6  and dimension is products.

want to draw a bar chart where dimension will be products name and in expression there would be my D-growth calculation (Those product will be displayed which are behind the target)

I use this formula:

=if(sum(ExtInvMisc)<sum(TargetAmount),ColumnName)

but its not working.

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Thanks to all......I did it..


Below expression works as i want;

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))

View solution in original post

4 Replies
Highlighted

Can you try this?

=if(sum({<ExtInvMisc = {"=Sum(ExtInvMisc)=10"}>} ExtInvMisc)<sum({<TargetAmount = {"=Sum(TargetAmount)=6"}>} TargetAmount),ColumnName)

Or


If(Sum(Sales) = 6 and Sum(target) = 10. Column)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Specialist
Specialist

Can you share your data in excel format?

Highlighted
Creator
Creator

Thanks to all......I did it..


Below expression works as i want;

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))

View solution in original post

Highlighted
Specialist
Specialist

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))