Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

WTD based on selection of year, month and day

Hi all,

i've got a calendar table with Date, day, week, month, year.

This calandar is connected to some fact tables.

If i select a year, a month and a day then automatically a weeknumber is returned.

For a report I want to get this weeknumber to calculate the WTD. But if I selected a week in the past, it should also show that weeks to date. So basically the week to date is based on the users selection.

But if you dont select the week itself, you cant use Getfieldselections. Is there another way to create the WTD.

I wanted to use set analysis for this, but i need the weeknumber.

Any help is appreciated

Tnx in advance,

Rey-man

Tags (2)
Community Browser