Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
yogitamehta10
Contributor

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

Re: absolute and Relative value using dual function in stack bar chart

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)
9 Replies
Or
Valued Contributor II

Re: absolute and Relative value using dual function in stack bar chart

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

Re: absolute and Relative value using dual function in stack bar chart

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
Contributor

Re: absolute and Relative value using dual function in stack bar chart

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
Contributor

Re: absolute and Relative value using dual function in stack bar chart

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
Valued Contributor II

Re: absolute and Relative value using dual function in stack bar chart

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
Contributor

Re: absolute and Relative value using dual function in stack bar chart

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

Re: absolute and Relative value using dual function in stack bar chart

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

Re: absolute and Relative value using dual function in stack bar chart

Thanks

Re: absolute and Relative value using dual function in stack bar chart

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)