topic Hi Experts... Issue About Trend Period in QlikView

Hi Experts... Issue About Trend Period

vangurideepu — Wed, 25 Nov 2020 16:16:04 GMT

i want display trend lines for each year, but i got only present year

can anybody help me out.

My achievement like below image..

Thanks in advance

Regards

Pradeep

Re: Hi Experts... Issue About Trend Period

Anonymous — Tue, 06 Dec 2016 07:02:40 GMT

Your data only has one year or when you create it, it only shows one year?

Re: Hi Experts... Issue About Trend Period

nagarjuna_kotha — Tue, 06 Dec 2016 07:10:07 GMT

Hi ,

Check this...

Exp: Sum({<[Order Year]>}Value) (It will exclude year selections )

Script:

LOAD * INLINE [

Order Year, Month, Value

2015, Jan, 1383

2015, Feb, 3451

2015, Mar, 1570

2015, Apr, 1730

2015, May, 1961

2015, Jun, 3588

2015, Jul, 2738

2015, Aug, 3083

2015, Sep, 1305

2015, Oct, 3303

2015, Nov, 2481

2015, Dec, 1726

2014, Jan, 3052

2014, Feb, 1290

2014, Mar, 3562

2014, Apr, 3016

2014, May, 1308

2014, Jun, 2721

2014, Jul, 2171

2014, Aug, 1963

2014, Sep, 2851

2014, Oct, 1388

2014, Nov, 2321

2014, Dec, 1379

2013, Jan, 1396

2013, Feb, 3166

2013, Mar, 3121

2013, Apr, 2635

2013, May, 2709

2013, Jun, 2810

2013, Jul, 2765

2013, Aug, 2698

2013, Sep, 3562

2013, Oct, 2834

2013, Nov, 2603

2013, Dec, 2477

2012, Jan, 2687

2012, Feb, 2175

2012, Mar, 1523

2012, Apr, 2941

2012, May, 1656

2012, Jun, 1282

2012, Jul, 3348

2012, Aug, 1904

2012, Sep, 3311

2012, Oct, 3187

2012, Nov, 1791

2012, Dec, 1321

2016, Jan, 3189

2016, Feb, 3294

2016, Mar, 2877

2016, Apr, 1349

2016, May, 2401

2016, Jun, 2027

2016, Jul, 1848

2016, Aug, 2984

2016, Sep, 1954

2016, Oct, 3083

2016, Nov, 3422

2016, Dec, 2731

];

Re: Hi Experts... Issue About Trend Period

nagarjuna_kotha — Tue, 06 Dec 2016 07:12:30 GMT

Re: Hi Experts... Issue About Trend Period

nagarjuna_kotha — Tue, 06 Dec 2016 07:17:49 GMT

But As per ur screenshot,

U should take expressions on Year wise , Like

Exp's:

2016: Sum({<[Order Year]={2016}>}Value)

2015: Sum({<[Order Year]={2015}>}Value) etc.......

and Dimension Should be only on i.e Month

I hop his might helps you.

-Nagarjun

Re: Hi Experts... Issue About Trend Period

jagan — Tue, 06 Dec 2016 07:22:22 GMT

Hi,

What is your expression? Are you selecting any year in the filter?

Try like this

=Sum({<YearFieldName=>}Sales)

***YearFieldName=, this will ignore Year selection, so it will display all years info.

Regards,

Jagan.

Re: Hi Experts... Issue About Trend Period

muthukumar77 — Tue, 06 Dec 2016 16:07:41 GMT

Hi,

Sum({<OrderYear=,OrderMonthName=>}Sales)