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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

problem with a chart (set analysis)

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

how can i do it?

hope im clear

19 Replies
sasikanth
Master
Master

Hi,

Try some thing like this

sum({Purcahse_MONTH=p({<month_sales ={'11/2015'}>}month_sales )  >}SO_Purchase)

adiarnon
Creator III
Creator III
Author

not working

adiarnon
Creator III
Creator III
Author

not working

adiarnon
Creator III
Creator III
Author

i cant chnge my schema

adiarnon
Creator III
Creator III
Author

not working

adiarnon
Creator III
Creator III
Author

i dont understand the solution

swuehl
MVP
MVP

I don't think that set analysis will solve your issue.

But instead of repeating 'not working', I would try to add more information about your data model, best by uploading some sample data or a small sample QVW.

Adding a small data island in your model to create a common date dimension might also solve your issue, if you don't want to use the canonical date linked to your data. But this will also imply a change to the model and I understood that you don't want to do this (but haven't understood why).

sfatoux72
Partner - Specialist
Partner - Specialist

Sorry, I just saw that Sales_Month is a dimension of your chart. You couldn't use set analysis in this case, because set analysis is calculated outside the graph.


Try this:

sum(if(Purcahse_MONTH = Sale_Month, SO_Purchase))

I use your original formula for the name of the field.

--> Warning :

  •      Typo in "Purcahse_MONTH"
adiarnon
Creator III
Creator III
Author

i dont have access from my developer computer to the web so i cant upload a qvw

awhitfield
Partner - Champion
Partner - Champion

Then copy it to another Pc that you have got web access on

Andy