topic Re: problem with a chart (set analysis) in QlikView

problem with a chart (set analysis)

adiarnon — Sun, 13 Mar 2016 13:47:29 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) ??????

how can i do it?

hope im clear

Re: problem with a chart (set analysis)

Chanty4u — Sun, 13 Mar 2016 14:04:30 GMT

sum({<Purcahse_MONTH={$(Sale_Month)}>}SO_Purchase)

Re: problem with a chart (set analysis)

swuehl — Sun, 13 Mar 2016 14:04:47 GMT

* i dont want to change my schema

I think that would indeed the best solution, see Canonical Date

Re: problem with a chart (set analysis)

adiarnon — Sun, 13 Mar 2016 14:37:24 GMT

not working

Re: problem with a chart (set analysis)

adiarnon — Sun, 13 Mar 2016 14:37:49 GMT

i dont want to change my schema

Re: problem with a chart (set analysis)

Chanty4u — Sun, 13 Mar 2016 14:42:00 GMT

chk dis

A Primer on Set Analysis

Why is it called Set Analysis?

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 07:21:52 GMT

any more ideas?

Re: problem with a chart (set analysis)

Kushal_Chawda — Mon, 14 Mar 2016 07:42:45 GMT

I think the best way is already suggested by swuehl‌.

You can try this as well by creating the table. For that You have to change the schema.

Sales:

load Sales_amount as Amount,

Sales_Month as Month,

'Sales' as Flag

From table;

concatenate

load Purchase_amount as Amount,

Purchase_Month as Month

'Purchase' as Flag

From table

Re: problem with a chart (set analysis)

jagan — Mon, 14 Mar 2016 07:43:46 GMT

Hi,

Try

sum({<Purcahse_MONTH=P(Sale_Month)>}SO_Purchase)

Regards,

jagan.

Re: problem with a chart (set analysis)

sfatoux72 — Mon, 14 Mar 2016 07:44:37 GMT

Try that:

sum({<Purcahse_MONTH={'$(Sale_Month)'}>}SO_Purchase)

Re: problem with a chart (set analysis)

sasikanth — Mon, 14 Mar 2016 07:50:18 GMT

Hi,

Try some thing like this

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

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 08:09:55 GMT

not working

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 08:10:10 GMT

not working

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 08:22:03 GMT

i cant chnge my schema

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 08:22:18 GMT

not working

Re: problem with a chart (set analysis)

adiarnon — Mon, 14 Mar 2016 08:22:39 GMT

i dont understand the solution

Re: problem with a chart (set analysis)

swuehl — Mon, 14 Mar 2016 08:29:05 GMT

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

Re: problem with a chart (set analysis)

sfatoux72 — Mon, 14 Mar 2016 08:32:37 GMT

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"

Re: problem with a chart (set analysis)

adiarnon — Wed, 16 Mar 2016 14:06:28 GMT

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

Re: problem with a chart (set analysis)

awhitfield — Wed, 16 Mar 2016 14:52:22 GMT

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

Andy