Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
yogitamehta10
Creator
Creator

absolute and Relative value using dual function in stack bar chart

Hi ALL,

i want to show absolute and relative using  dual function in qlikview stack bar chart .

e.g 40(12%)

my expression for calculating absolute value is   sum(sales).

relative values is sum(spend)/sum(sales)


any ideas?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Mine, Won't help for you? I thought to show in document. Can you check this

Capture.PNG

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)

View solution in original post

9 Replies
Or
Specialist III
Specialist III

I'm not really sure what the question is. If you want to use the dual function for this, why not use the dual function for this?

Dual(sum(Sales),sum(spend)/sum(sales))

Anil_Babu_Samineni

Perhaps this?

Dual(sum(Sales) & '(' & Num((sum(spend)/sum(sales)),'#,##,#0%') & ')',sum(sales))

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)
yogitamehta10
Creator
Creator

Hi ALL,

i want to show two  value in stack bar chart , Not sure how to do that ?

e.g 40(12%)

my expression for calculating a value is   sum(sales).

% values is sum(spend)/sum(sales)

Bar should not be effected by  % value

any ideas?

yogitamehta10
Creator
Creator

Hi ALL,

i want to show two  value in stack bar chart , Not sure how to do that ?

e.g 40(12%)

my expression for calculating a value is   sum(sales).

% values is sum(spend)/sum(sales)

Bar should not be effected by  % value

any ideas?

Or
Specialist III
Specialist III

The best idea I have for you is - don't.

You shouldn't display a stacked bar where one value is numeric (a number, e.g. sales) and the other is relative (e.g. % profit). Stacking these does nothing except making them difficult to read - there's no sense to be made from one bar being taller than another if they're composed of two completely unrelated values.

Instead, use separate bars (with a separate axis) or better yet, a combination chart with one value as a bar and the other as a dot.

yogitamehta10
Creator
Creator

This is what user want , I can't change the requirement

Anil_Babu_Samineni

Mine, Won't help for you? I thought to show in document. Can you check this

Capture.PNG

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)

View solution in original post

yogitamehta10
Creator
Creator

Thanks

Anil_Babu_Samineni

Great, Please flag correct answer. Ref - Qlik Community Tip: Marking Replies as Correct or Helpful

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)