topic Dimension to show values based on Current Week Value in QlikView

Dimension to show values based on Current Week Value

Wed, 04 Feb 2015 16:39:28 GMT

Hello QlikView Community!

I have been working to create a table that lists employees with the count of their sales and if they have no sales then I still want their name to show up with no value, null or 0. I haven't been successful yet,

I have attached a dashboard with a sample of my data.

How can I create straight table where the Employee field shows value based upon the current week from my [HR Payroll Week] field?

My original dashboard has a table a historical table of employees with a period weed ending date. I always want to show the latest week of employees in the dimension of my straight table. But I also want the dimension to ignore whenever I filter on a date that is associated with the Transaction (TransDate) and (Business Week). The Business Week is built off the TransDate.

Any help would be so appreciated. Thanks!

Robyn

Re: Dimension to show values based on Current Week Value

jpapador — Wed, 04 Feb 2015 17:24:37 GMT

So you always want you chart to show all employee sales regardless if they have any or not for the current payroll week? And if you start selecting dates in HR payroll week, business week or trans date you want those to be ignored?

Re: Dimension to show values based on Current Week Value

jpapador — Wed, 04 Feb 2015 17:27:29 GMT

Not sure if this is what you are looking for but PFA.

Uses a combination of set analysis and alternate states.

Re: Dimension to show values based on Current Week Value

Wed, 04 Feb 2015 18:04:09 GMT

Hi jpapador - Thanks for the response.

Yes, i want to show all employees regardless if they have sales or not for the payroll week. If I start selecting the HR payroll Week data, I want that to be ignored. If I select business week/trans date, I want the employee dimension to ignore those filter but the count of sales can change whenever I filter on those date fields.

I want to be able to see the most current payroll week of employees but filter on each business week to see if they have sales.

I hope this makes sense.

Thanks!

Re: Dimension to show values based on Current Week Value

Wed, 04 Feb 2015 18:10:10 GMT

Hello,

Look that.

Re: Dimension to show values based on Current Week Value

Wed, 04 Feb 2015 20:28:48 GMT

Hi Jpapador - I looked at the qvw you attached and I think it is almost there. I do want to be able to select a business week and see the counts for that week for each Employee. I want the count of sales to be dynamic with the business week and TransID. I just want the Employee list to remain static based on the most current HR Payroll Week.

Thanks for your help on this, you have definitely got me closer to what I am looking for.