topic Re: Use only 5 values for a dimension(date) in QlikView

Use only 5 values for a dimension(date)

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

Hi Community,

I need to solve a question.

I have a date field and I can select any date for all document.

Now I need to create a line chart who uses date as dimension and sum(Clients) as expression.

The problem is that I need to use only selected week and four previous weeks.

Can anybody help me?

Regards

Miguel del Valle

Re: Use only 5 values for a dimension(date)

kaushiknsolanki — Wed, 17 Aug 2016 13:22:53 GMT

Hi,

Then your expression will be.

Sum({<Date = {">=$(=weekstart(Max(Date)-28))>=$(=Max(Date))"},Week=>}Clients)

Regards,

Kaushik Solanki

Re: Use only 5 values for a dimension(date)

sunny_talwar — Thu, 18 Aug 2016 01:56:02 GMT

Kaushik -

I think you meant this:

Sum({<Date = {">=$(=WeekStart(Max(Date)-28))<=$(=Max(Date))"},Week=>}Clients)

Re: Use only 5 values for a dimension(date)

kaushiknsolanki — Thu, 18 Aug 2016 04:19:08 GMT

Thanks Sunny..

Re: Use only 5 values for a dimension(date)

migueldelval — Thu, 18 Aug 2016 06:40:10 GMT

Hi Sunny & kaushik.solanki,

Your option it´s correct, Thanks.

But only If I use:

=Sum({<Semana={">=$(=WeekStart(Max(Semana)-28))<=$(=Max(Semana))"}>}Clients)

Do you Know why?

Regards

Miguel del Valle

Re: Use only 5 values for a dimension(date)

sunny_talwar — Thu, 18 Aug 2016 07:10:17 GMT

So you mean if you remove Week =, then it works, otherwise it won't? Do you have a Week field in your application?? if you don't then kaushik.solanki‌ used Week field just as placeholder for your actual field. And the reason to add Week = in there is to ignore any selection in week field. If you don't plan to make selections in week field, then you might not even need it.

Best,

Sunny

Re: Use only 5 values for a dimension(date)

migueldelval — Thu, 18 Aug 2016 07:34:36 GMT

Thanks Sunny,

The Mistake was in my question. I spoke about "select a week", but I only have date field and I make week(date) to refill dimension.

Regards

Miguel del Valle