topic Re: 1 chart two expression from different data sources in QlikView

1 chart two expression from different data sources

Thu, 06 Aug 2015 20:17:46 GMT

Hello,

Quick Question, I have two data sets that have nothing to do with each other and way different columns, but I want to use both in a stacked chart as percentages, I just want their result percentage values of each expression stacked on top of each other, so 1 chart ,two data sets, 2 expressions, stack the percentages on top of each other. Qlikview charts wont let me becuase the dimension would only apply to one expression and not both, breaking the chart.

IS there some way to put a condition on a dimension to only apply to a particular expression?

I've done this before by creating 20+ variables for each situation on one data set, then and using those against the other data set in an expression, but that won't work in this case, way to many cases.

Does any one know how to include two data sets in one bar chart, without breaking it due to the dimension not applying to both?

Thanks ahead of time

Re: 1 chart two expression from different data sources

Clever_Anjos — Thu, 06 Aug 2015 20:20:13 GMT

The second expression, what you want to see? All values of each dimension for first expression should be equal?

Re: 1 chart two expression from different data sources

Thu, 06 Aug 2015 20:24:36 GMT

What to see would be a stacked chart with one section being the first expression, the other section of hte stacked chart would be the second expression, but the dimension can only apply to one data set , not both...

All values of each dimension would not be equal no, and I'm aggregating on them anyway, the reslut is a percentage %.

Re: 1 chart two expression from different data sources

Thu, 06 Aug 2015 20:28:57 GMT

Something like if(Expression = Expression A, Dimension 1, if(Expression = Expression B, Dimension 2))

I want this to be my dimension if possible or something like it, I would like to utilize two dimensions in a bar chart, based on the expression, mine having 2 expressions

Re: 1 chart two expression from different data sources

ogster1974 — Thu, 06 Aug 2015 20:44:43 GMT

‌try mocking your chart up you want to see in paint or excel and post here I think it will help people to see an example.

Re: 1 chart two expression from different data sources

Thu, 06 Aug 2015 20:48:20 GMT

Yes. Please provide a mock up. Sir.

Re: 1 chart two expression from different data sources

Thu, 06 Aug 2015 21:07:27 GMT

Re: 1 chart two expression from different data sources

Thu, 06 Aug 2015 21:19:40 GMT

Can you create a dummy column on both tables so you can join them?

Re: 1 chart two expression from different data sources

ogster1974 — Fri, 07 Aug 2015 06:42:59 GMT

‌thanks for the mockup can you add your axis to it. How you expect it to behave. I like the suggestion cooker has made to add a new column to join your tabl

Re: 1 chart two expression from different data sources

Kushal_Chawda — Fri, 07 Aug 2015 06:49:52 GMT

what is the dimension of the chart. Is your dimension available in both data set?

Re: 1 chart two expression from different data sources

Fri, 07 Aug 2015 14:26:14 GMT

I do not believe a dummy column would be possible, due to one data source is a sum off a spreadsheet, the other a sum out of a database, there isn't any type of relationship between the data, just trying to calculate each expression in percent, then stack them on top of each other, since they are so different a dummy column probably wouldn' work due to how they are aggregated differently. Thanks though

Re: 1 chart two expression from different data sources

Fri, 07 Aug 2015 14:28:59 GMT

x axis would be current year and previous year, like 2014 2015, for behavoir just looking for a stacked chart, one expression on top of the next, it would be easy if I had the same dimension for each data set but thats not possible here, due to them being data islands. Thanks

Re: 1 chart two expression from different data sources

ogster1974 — Fri, 07 Aug 2015 14:37:14 GMT

why can't you create a field in each table call year and populate it with the relevant date? Qlik would do the rest by adding year as your dimension you could stack as you want.

If they need to remain separated add a master calendar with year and have a field called tableayear and tablebyear in your other tables then use year as your dimension and in your expression include in set analysis tableayear=p(year) and in the other tablebyear=p(year)

Hope this helps

Regards

Andy

Re: 1 chart two expression from different data sources

Fri, 07 Aug 2015 14:41:42 GMT

Step1: in loading script, load the aggregated query like

Select year, sum(sales) from source1;

Step2: in the loading script load the aggregated query like

Select year,sum(sales) from source2;

Then they can be joined.

Right?

发自我的 iPhone

在 Aug 7, 2015，10:29 AM，Brad Estep <qcwebmaster@qlikview.com> 写道：
1 chart two expression from different data sources
reply from Brad Estep in App Development - View the full discussion
x axis would be current year and previous year, like 2014 2015, for behavoir just looking for a stacked chart, one expression on top of the next, it would be easy if I had the same dimension for each data set but thats not possible here, due to them being data islands. Thanks
Reply to this message by replying to this email, or go to the message on Qlik Community
Start a new discussion in App Development by email or at Qlik Community
Following 1 chart two expression from different data sources in these streams: Inbox
© 1993-2015 QlikTech International AB | Copyright & Trademarks | Privacy | Terms of Use | Software EULA