topic set analysis in bar chart in QlikView

set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:01:59 GMT

hi,

i have a bar chart with a dimension of month_sales

i have a mesaure of purchase that conect to a dimention of month_purchase

my chart dimention is month_sales and and the expression is aum(sale_amnt)

but,

i want to add a expression of sum(purchase_amnt)

but i need that the value where the month_sales dimension =11/2015

it will show the sum(purchase_amnt) where month_purchase=11/2015

* i dont want to change my schema

somthing like-

sum({Purcahse_MONTH={(Sale_Month)}>}SO_Purchase) ??????

Re: set analysis in bar chart

ali_hijazi — Wed, 16 Mar 2016 14:03:48 GMT

sum(if(purchase_month=sales_month,purchase_amnt))

Re: set analysis in bar chart

ali_hijazi — Wed, 16 Mar 2016 14:04:41 GMT

or sum({<Purchase_Amnt={"Purchase_Month = Sales_Month"}>}Purchase_Amnt)

Re: set analysis in bar chart

sunny_talwar — Wed, 16 Mar 2016 14:10:12 GMT

May be this:

Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:10:30 GMT

tnx,

but i tried both and its still not working

Re: set analysis in bar chart

ali_hijazi — Wed, 16 Mar 2016 14:11:55 GMT

sum({<Purchase_Amnt={"=Purchase_Month = Sales_Month"}>}Purchase_Amnt)

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:17:40 GMT

not

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:20:45 GMT

Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)

what should i write SO_Purchase tha month or the amount?

Re: set analysis in bar chart

sunny_talwar — Wed, 16 Mar 2016 14:23:09 GMT

What's a unique field in your data base which makes the combination of Purcahse_MONTH and Sale_Month unique?

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:29:01 GMT

Re: set analysis in bar chart

sunny_talwar — Wed, 16 Mar 2016 14:31:49 GMT

I guess are you able to share a sample?

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:35:35 GMT

i cant

by this is my scheme

Re: set analysis in bar chart

adiarnon — Wed, 16 Mar 2016 14:38:07 GMT

sum({<SO_SAVE_MONTH={"(=SO_SAVE_MONTH=[Save Month])"},[Actual Calc]=,Year=,Month=>}SO_QTY_DEL)

this is the expression im tring to built

my dimention is [Save Month]

and i need the sum(SO_QTY_DEL) in this month but with SO_SAVE_MONTH

i cant insert the SO_SAVE_MONTH to the key table...