Need to create the same in qlikview appearing in excel

[anukumari]

Hi,

I have an excel sheet attached as follows and the requirement is to create the same thing in qlikview.

I tried by taking pivot table but the result didnt come as expected.

please suggest

[Anil_Babu_Samineni]

Yes, We can with Pivot Table.

[jpenuliar]

Something similar like this?

Calendar UI using Pivot table

[jpenuliar]

or a calendar chart like the one done by Rob Wunderlich

Search Recipes | Qlikview Cookbook

[anukumari]

Hi ,

Thanks Jonathan.

I was able to create pivot table based on the Calendar UI what Jonathan has sent...

But i was unable to display weekly average in the table..

Please suggest.

[jpenuliar]

Hi Anu,

Assuming you have created the pivot Table as  rwunderlich‌ 's example.

In the chart expression, try adding a few lines like :

& if(Match(Weekday,'Sat'),chr(10) & 'Weekly AVG Here')

& if(Match(Weekday,'Sat'),chr(10) & 'Weekly TOTAL Here')

this will add your figures in saturday cells.

notice how Rob's design for table StockPrice, where fields are [Date] & [ClosingAsk].

you can probably add 2 more fields [TOTAL] & [AVERAGE] and fill in values only on dates that falls on your weekend summary.

StockPrice:

Date,ClosingAsk,TOTAL,AVERAGE

[jpenuliar]

he'res what it looks like:

[anukumari]

Hi Jonathan,

Here i was able to display Weekly Total in a different column by checking the "show partial sums" check box in the presentation tab.

But the thing which i was unable to show is weekly average column for every week.

Please check the attachment which was done in qlikview and compare with the above attachment sent in previous discussion.

Thank you

[jpenuliar]

would you be able to attach your qlikview file.

my bet is you can work a complex expression in "Label for Totals" (next to "Show Partial Sums") using Dimensionality() and some othe fancy stuff to make it work.