topic Dashbord sum(TOTAL) in QlikView

Dashbord sum(TOTAL)

n1ef5ng1 — Mon, 03 Mar 2014 09:32:46 GMT

Hi all,

I am trying to create a dashboard for the user therefore, no selection is needed from the user input.

One of the expression that I would like to create is MarketShare by current year.

sum(sales) / sum(TOTAL(sales) will be the market share throughout, however I have ten years of data and I would like to only find the market share for this year.

sum({<Year={"$(=max({<Year=>} Year))"}>} sales)
/
sum(TOTAL(TEU)<Year = today())

I managed to get the first part correct, however on the second part, how can i find the total sales in one code

thanks

Re: Dashbord sum(TOTAL)

alexandros17 — Mon, 03 Mar 2014 09:41:03 GMT

sum({<Year={"$(=max({<Year=>} Year))"}>} sales)
/
sum(TOTAL {$ <Year={"$(=max({<Year=>} Year))"}, myCode = {'TEU'}>} Sales)

Re: Dashbord sum(TOTAL)

MK_QSL — Mon, 03 Mar 2014 09:50:04 GMT

sum({<Year = {'$(=Year(Today()))'}>}sales) / sum(TOTAL{'Year = {'$(=Year(Today()))'}'}sales)