topic Re: Grouping in dimensions in QlikView

Grouping in dimensions

Thu, 26 Nov 2015 06:49:16 GMT

Hi all,

I need a help for the below requirement.

I have the Month and product as dimension and sales as Expression.

Though the dimension is month i have to show th graph based on weekwise but in dimension it should be Month.

Ie. for Jan-15 there would be 4 weeks the n it should show the four points for Jan 15 as continuos pints in a line graph.

Looks like.

Re: Grouping in dimensions

Anonymous — Thu, 26 Nov 2015 06:53:02 GMT

I would suggest, take Month as a Dimension,

and then define 4/5 expression for your Sales like:

Week1= sum({<Weekname={'Week 1'}>}Sales)

Week2= sum({<Weekname={'Week 2'}>}Sales)

Week3= sum({<Weekname={'Week 3'}>}Sales) and so on...

Hope this will help!!

Re: Grouping in dimensions

Gysbert_Wassenaar — Thu, 26 Nov 2015 07:05:05 GMT

A line chart cannot have three dimensions. Create a WeekStart field in the script from the date field using the WeekStart function, i.e. WeekStart(MyDate) as MyWeek, and use that new WeekStart field as dimension in your chart. Then set the dimension axis to Continuous on the Axes tab and set the Number format of the Continuous X-axis to Date with MMM/YY as date format on the Number tab.

Re: Grouping in dimensions

NareshGuntur — Thu, 26 Nov 2015 07:05:07 GMT

Have you tried taking Week as well in the dimension?

Cheers,

Naresh

Re: Grouping in dimensions

tresB — Thu, 26 Nov 2015 07:08:03 GMT

Replace your Month dimension by calculated dimension, something like : =Dual (Month, Week)

Assuming there is a week field called Week in your data model.

Re: Grouping in dimensions

Thu, 26 Nov 2015 08:24:57 GMT

Hi,

Thanks a lot for your help.

It worked for me. but the Month name is repeated for each weeks.is there any possible way to show only one Month for four four weeks..?

Re: Grouping in dimensions

Anonymous — Thu, 26 Nov 2015 08:28:41 GMT

What I suggested that might not repeat the Months

Re: Grouping in dimensions

tresB — Thu, 26 Nov 2015 08:42:01 GMT

Try like:

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week), Week)

Re: Grouping in dimensions

Thu, 26 Nov 2015 08:51:52 GMT

Yea...but for me the weeks are defined with each weekending Date..so i have to write expressions for each and every week of the year....

Re: Grouping in dimensions

Thu, 26 Nov 2015 08:52:12 GMT

Thanks a lot...It worked..

Re: Grouping in dimensions

tresB — Thu, 26 Nov 2015 08:56:07 GMT

Please close the thread by marking correct/helpful replies.

Re: Grouping in dimensions

Gysbert_Wassenaar — Thu, 26 Nov 2015 09:10:56 GMT

If your week values are already defined as WeekEnd dates then simply set the dimension axis to Continuous and change the Number format of the Continuous X-axis to a Date format with MMM/YY as format string.

Re: Grouping in dimensions

buzzy996 — Thu, 26 Nov 2015 09:24:46 GMT

the other simplest way is if u don't have weeks field in source/load script u can create that field first and use both week & month as your dimension fields in ur chart with sum(sales) as expression.

hope, tht solves ur issue.

Re: Grouping in dimensions

Mon, 30 Nov 2015 06:53:39 GMT

hi all...

one more querry..

how can i display the max and min values in the chart..as values on data points..

Regards,

Reena

Re: Grouping in dimensions

tresB — Mon, 30 Nov 2015 07:05:18 GMT

Hi Reena,

I suggest you to close this thread by marking correct and open a new one with this new query.

Re: Grouping in dimensions

Mon, 30 Nov 2015 07:18:56 GMT

i am not able to mark correct for this thread...thats why i added it s helpful reply..

Re: Grouping in dimensions

tresB — Mon, 30 Nov 2015 07:26:05 GMT

That is perhaps because, you did not mark this discussion as a question. Create a new thread and don't forget to mark that so this time because that helps you find more people answering.

For this thread mark the right replies helpful. That would help others find the solution with similar problem.