Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

set analysis in bar chart

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) ??????

Labels (1)
12 Replies
sunny_talwar

I guess are you able to share a sample?

adiarnon
Creator III
Creator III
Author

i cant

by this is my scheme

adiarnon
Creator III
Creator III
Author

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...