topic Re: Accumulation data till Max(Today) in QlikView

Accumulation data till Max(Today)

renuka_sasikumar — Wed, 05 Jul 2017 04:53:06 GMT

Hi,

When I check on Full Accumulation in Line Chart for comparison between MTD & LYMTD I get the data & the look what I want it, But while doing this for current month its should consider only Max(Today).

I have attached the snapshot of Line Chart, my data should show till 25th Jun,2017, whereas it is showing me till 30th June 2017.

Can anyone help on this.

Regards,

Renuka S

Re: Accumulation data till Max(Today)

tresB — Wed, 05 Jul 2017 05:05:33 GMT

Could you please share your sample qvw?

Re: Accumulation data till Max(Today)

renuka_sasikumar — Wed, 05 Jul 2017 06:21:11 GMT

Thanks for your prompt reply.

Is it possible without the app. Can't share it due to some reason.

Regards,

Renuka S

Re: Accumulation data till Max(Today)

tresB — Wed, 05 Jul 2017 06:26:06 GMT

Probably possible. But for that I have to create a sample; ask you many questions in the follow ups. Better you help us help you creating a sample (if you can't share your app). Please check: Preparing examples for Upload - Reduction and Data Scrambling

Re: Accumulation data till Max(Today)

renuka_sasikumar — Wed, 05 Jul 2017 10:02:33 GMT

Hi,

Kindly find the attached QVW.

Regards,

Renuka S

Re: Accumulation data till Max(Today)

tresB — Wed, 05 Jul 2017 11:17:04 GMT

You have to work a bit with 'Background Color' and 'Show Value' property like in attached sample.

Re: Accumulation data till Max(Today)

renuka_sasikumar — Wed, 05 Jul 2017 11:40:18 GMT

Thank You very much 🙂

It worked.

Regards,

Renuka S