topic Re: Problem with combining two sources in the single chart in QlikView

Problem with combining two sources in the single chart

Tue, 09 Sep 2014 09:25:23 GMT

Hello everyone,

Please look into the sample qvw file, i have year, and two charts from two different source,

PAST chart having only the data for past months ( for current month till date)

PAST and FUTURE chart having past month, from tomorrow till month end and future month.

i need to create a chart with past data(Source1.Revenue). from past month, future data from past and future chart(Source2.Revenue).

if you select 2014 the chart should have three bars, combining past and future.

the data should aggregate based on the current date.

If data aggregation is not possible on the date, we can show the past data till previous month, future data from current month

Thanks

Re: Problem with combining two sources in the single chart

rubenmarin — Tue, 09 Sep 2014 09:42:12 GMT

Hi Sreeharsha,

I'm not sure to understand the requirements, you searching for an expression like?:

=Sum({<Date={'<$(=Today())'}>}Combine_fact.Source1.Revenue) + Sum({<Date={'>=$(=Today())'}>} [Source2-1.Source2.Revenue])

=Sum({<Date={'<$(=MothStart(Today()))'}>}Combine_fact.Source1.Revenue) + Sum({<Date={'>=$(=MonthStart(Today()))'}>} [Source2-1.Source2.Revenue])

Hope this helps.

Regards.

Re: Problem with combining two sources in the single chart

avinashelite — Tue, 09 Sep 2014 09:42:47 GMT

Hi Sreeharsha,

I did not get your exact requirement, please see the attached file.

Please post the snapshot of what your trying to achieve and explain it.

Re: Problem with combining two sources in the single chart

Tue, 09 Sep 2014 10:03:57 GMT

Hello Avinash,

i need to show the past data from one measure, future data from one measure. i have two different measures.

i can not combine two measures, because first measure having past data, and second measure having past and future data

Thanks

Re: Re: Problem with combining two sources in the single chart

rubenmarin — Tue, 09 Sep 2014 10:13:14 GMT

Hi,

Again not sure of the exact requirements, check the attached file.

Regards

Re: Problem with combining two sources in the single chart

Tue, 09 Sep 2014 10:40:45 GMT

Thanks Ruben,

You got my issue, but i don't need those past and future values, since i have too many measures to show in the chart, i tried to remove those things and checked, it i snot working.

Can we have only one value without any legend

Thanks again, it will be great help

Re: Problem with combining two sources in the single chart

rubenmarin — Tue, 09 Sep 2014 10:49:33 GMT

Glad to help

In my last example i added two graphs, the bottom-right graph has the past and future values, the bottom-left graph has the same calculations in one value.

Using the bottom-left graph meets your requirements?

Regards.

Re: Problem with combining two sources in the single chart

Tue, 09 Sep 2014 11:05:36 GMT

Thanks Ruben for quick response

yes bottom-left graph is my requrements, both in one value, but no legend i needed. without colors.

Thanks

Re: Problem with combining two sources in the single chart

Wed, 10 Sep 2014 05:26:01 GMT

Can any body tell what is the problem with this expression, i wrote this syntax for above scenario, i am getting the values for the past from measure1, am not getting fueture values from measure2.

=avg({<Date={'<=<$(=Today())'}>}measure1) + avg({<Date={'>=$(=Today())'}>}[measure2)

Thanks

Re: Re: Problem with combining two sources in the single chart

rubenmarin — Wed, 10 Sep 2014 06:50:28 GMT

I see something that may be incorrect:

=avg({<Date={'<=<$(=Today())'}>}measure1) + avg({<Date={'>=$(=Today())'}>}[measure2)

That <= shouldn't be there, only the '<' I left black, if you get '<=', today values are get from past and future measure.

=avg({<Date={'<=<$(=Today())'}>}measure1) + avg({<Date={'>=$(=Today())'}>}[measure2)

That '[' is a typo or is really there?

Corrected expression could be:

=avg({<Date={'<$(=Today())'}>}measure1) + avg({<Date={'>=$(=Today())'}>}measure2)