how to apply YTD to list box in qlikview - Qlik Community

Anonymous · ‎2018-01-22

Hi All

I have requirement where I need to apply YTD calculation in the list box filters in the Qlikview dasboard.

Thanks

Vijay C

rahulpawarb · ‎2018-01-22

Hello Vijay,

Please refer the latest comment available on below link:

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

Hope this will help.

Regards!

Rahul Pawar

Anonymous · ‎2018-01-22

Thanks Rahul !!!

My list box has does not have measure . it is dimension.

Any Suggestions

Thanks

Vijay C

rahulpawarb · ‎2018-01-22

If you are willing to add YTD at least box level by adding expression then follow below mentioned steps:

1. Add a list box for Product field

2. Add an expression: Sum({<Date={">=$(=YearStart(Max(Date))) <=$(=Max(Date))"}>}Sales)

Please correct me if I misinterpreted.

Sample Data:

Data:

LOAD * INLINE [

Date, Product, Sales

01/01/2017, Product 1, 1000

01/02/2017, Product 1, 2000

01/03/2017, Product 1, 3000

01/04/2017, Product 1, 4000

01/01/2017, Product 2, 1100

01/02/2017, Product 2, 2200

01/03/2017, Product 2, 3300

01/04/2017, Product 2, 4400

01/01/2018, Product 1, 1200

01/02/2018, Product 1, 2200

01/03/2018, Product 1, 3200

01/04/2018, Product 1, 4200

01/01/2018, Product 2, 1400

01/02/2018, Product 2, 2400

01/03/2018, Product 2, 3400

01/04/2018, Product 2, 4400

];

Anonymous · ‎2018-01-22

I have 3 list box in the dashboard

1. Month and YTD

2. Period ( 2017-12,2017-11,2017-10,2017-09....)

3.Products

y List box has only dimension. When I select Month in list box(1) then month wise products will be displaced for that month. If I select YTD(1) then YTD should be displayed in the Product list box.

Please let know if u require information on this.

Thanks

Vijay C

7200092302