topic Re: get current week as dimension in Bar chart in QlikView

get current week as dimension in Bar chart

markgraham123 — Thu, 06 Aug 2015 22:39:11 GMT

Hi Everyone,

I'm working on a bar chart, where X-axis should be current week latest 7 days.

I tried =(WeekDay) in dimension

but no luck.

Can someone help pls.

Re: get current week as dimension in Bar chart

swuehl — Thu, 06 Aug 2015 22:47:29 GMT

Not much information given about the fields in your data model etc.

Just guessing, try a calculated dimension like

=If ( DateField >= Today()-7 and DateField <=Today(), DateField)

Replace DateField with your date field.

Re: get current week as dimension in Bar chart

Gabriel — Thu, 06 Aug 2015 23:02:11 GMT

Hi,

What does you data model looks like?

What field do you have to generate the date from?

More information will be helpful

Re: get current week as dimension in Bar chart

MarcoWedel — Thu, 06 Aug 2015 23:13:41 GMT

you could also limit the dates using a set expression or with dimension limits.

hope this helps

regards

Marco

Re: get current week as dimension in Bar chart

Anonymous — Thu, 06 Aug 2015 23:59:42 GMT

Or, if you reload at least once a day, create an additional field in your calendar that includes the last 7 days, and use it as chart dimension.

Re: get current week as dimension in Bar chart

markgraham123 — Fri, 07 Aug 2015 00:00:13 GMT

Hi,

There is a date field.

But cant i take by specifying today() function rather than using any field in the data model??

I mean by using Set analysis??

Re: get current week as dimension in Bar chart

markgraham123 — Fri, 07 Aug 2015 00:00:58 GMT

Hi,

I have a "date" field.

Re: get current week as dimension in Bar chart

markgraham123 — Fri, 07 Aug 2015 00:01:49 GMT

Hi Michael,

That is what i'm exactly looking for.

I was struck how to generate a dimension using Today() function to get latest 7 days starting from yesterday..

Can you please throw some lime light..

Re: get current week as dimension in Bar chart

tchovanec — Fri, 07 Aug 2015 01:40:56 GMT

Mark,

I have attached an example of building a master calendar along with a date concept table. You can create a date concept for the last 7 days and then use that is set analysis to get the last 7 days all the time.

Re: get current week as dimension in Bar chart

markgraham123 — Fri, 07 Aug 2015 01:44:36 GMT

Thanq Thomas