topic Re: Need help in QlikView

Need help

Tue, 17 Jun 2014 07:44:30 GMT

Hi all

I have problem with bar char. In stright table i got corrent sales and sales % of total, but when i use similar expresion on yearmonth dimension in bar char i got incoret values. What i need: in bar char for each month, char max and min value of bar must bee 100%, and all sales are distributed according to % of total sales. (like in atached picture).

Please help.

Re: Need help

MK_QSL — Tue, 17 Jun 2014 07:51:34 GMT

Change your expression as below

sum(TOTAL <PERIOD, [BRAND OWNER]> [Sales Volume 1000 Kgs/Ltrs/Pcs])

Re: Need help

Gysbert_Wassenaar — Tue, 17 Jun 2014 07:54:37 GMT

Disable the option Relative and change the expression to:

sum([Sales Volume 1000 Kgs/Ltrs/Pcs])/sum(total <[PERIOD]>[Sales Volume 1000 Kgs/Ltrs/Pcs])

See attached qvw.

Re: Need help

Tue, 17 Jun 2014 08:00:31 GMT

thanks!!!

Re: Need help

Tue, 17 Jun 2014 08:01:09 GMT

Hi Sigitas

here it is

it is better not to use keys (PERIOD) in your graph

best regards

Chris