topic Re: previous diff want to add present quarter value in QlikView

previous diff want to add present quarter value

Wed, 25 Nov 2020 16:16:04 GMT

hi i have one chat ,that chart contains budget value and actual value ,

i have to add previous diff values(budget value-actual value) to current quarter budget value

how to do?

please help me

thanks in advance

Re: previous diff want to add present quarter value

sunny_talwar — Thu, 13 Oct 2016 14:12:42 GMT

You want this?

Re: previous diff want to add present quarter value

Anil_Babu_Samineni — Thu, 13 Oct 2016 14:18:05 GMT

Might be this file was corrupted, Try to update new one. I am getting error while hitting (Failed to Open)

OR Post on the wall Expression

Re: previous diff want to add present quarter value

Fri, 14 Oct 2016 03:51:06 GMT

hi stalwar1

i want only current quarter (q3)

Re: previous diff want to add present quarter value

Fri, 14 Oct 2016 04:03:10 GMT

i want like this but only for current quarter and and also display actuals (next to budget in every quarter

Re: previous diff want to add present quarter value

Anil_Babu_Samineni — Fri, 14 Oct 2016 05:06:12 GMT

What expression is there for This graph which is Stacked.

Re: previous diff want to add present quarter value

Fri, 14 Oct 2016 05:14:15 GMT

HI Anil babu,

i have total 3 expressions

i want to show 2 expressions as grouped

and remain one as stacked

is it possible in one chart

thanks in advance

Re: previous diff want to add present quarter value

sunny_talwar — Sat, 15 Oct 2016 11:17:39 GMT

Is this the goal?

Added an Island table which I will use as a second dimension

Dim:

LOAD * Inline [

Dim

];

Bar Chart Dimensions

budget_QName

Dim

Bar Chart Expressions

Budget

=If(Dim = 1, Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=>} budget_BudgetValue)/Value)

New piece for current quarter

=If(Dim = 1 and budget_QStartDate <= Today(1) and budget_QEndDate >= Today(1),

RangeSum(Above(TOTAL If(Dim = 1, Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=>} budget_BudgetValue)/Value - Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=,BudgetRev_st_probability={'100'} >}BudgetRevRevForecasted)/Value), 1, RowNo(TOTAL))))

Actual

=If(Dim = 2, Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=,BudgetRev_st_probability={'100'} >}BudgetRevRevForecasted)/Value)

Re: previous diff want to add present quarter value

sunny_talwar — Sat, 15 Oct 2016 11:19:39 GMT

I think I mistakenly did full accumulation for Actual. Here is the right image and the right sample

Re: previous diff want to add present quarter value

Mon, 17 Oct 2016 12:15:06 GMT

superb,

thank you so much

Re: previous diff want to add present quarter value

Mon, 17 Oct 2016 12:28:39 GMT

for showing total and sub total which option i have to select

Re: previous diff want to add present quarter value

sunny_talwar — Mon, 17 Oct 2016 12:40:21 GMT

You need to check these two boxes on the Presentation tab

Re: previous diff want to add present quarter value

Mon, 17 Oct 2016 12:45:44 GMT

am using qv11 sr2 in this that option is not there

thank you

Re: previous diff want to add present quarter value

sunny_talwar — Mon, 17 Oct 2016 12:48:19 GMT

Yes, this was introduced in later versions or QV 11.20. If it is not there, you won't be able to use them