topic Re: Set analysis Calculate Total on bar chart in QlikView

Set analysis Calculate Total on bar chart

Tue, 22 Mar 2016 16:43:03 GMT

Hello Everyone,

I try to create a bar chart to calculate revenue percentage for each group.The Dimension is Division.

Current Month:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

YTD:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {"<=$(#=Only(_Month))"}, Division= >} [Revenue])

Is there a way to let the set analysis calculate the total for all Division on this bar chart?

Thank you very much in advance!

Re: Set analysis Calculate Total on bar chart

sunny_talwar — Tue, 22 Mar 2016 16:45:00 GMT

Add another bar for TOTAL? Is that what you are looking for?

Re: Set analysis Calculate Total on bar chart

Tue, 22 Mar 2016 16:51:23 GMT

Thank you - Sunny,

I need a bar chart show (Revenue by Division)/ (Total Revenue of all the Division)

Thanks.

Re: Set analysis Calculate Total on bar chart

sunny_talwar — Tue, 22 Mar 2016 16:53:14 GMT

Try selecting relative option on the expression tab.

this may be:

=Sum({$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])/Sum(TOTAL {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

Re: Set analysis Calculate Total on bar chart

swuehl — Tue, 22 Mar 2016 16:53:35 GMT

Maybe using TOTAL qualifier:

Current Month:

=sum ( {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

sum (TOTAL {$<[FiscalYear] = {$(#=Only(_Year))}, [FiscalMonth] = {'$(#=Only(_Month))'}, Division= >} [Revenue])

Re: Set analysis Calculate Total on bar chart

Tue, 22 Mar 2016 16:58:53 GMT

Thank you very much - Sunny and swuel.

Works perfect.

You guys are great!

You have great day!