Year, month, week format?

[Anonymous]

Hi,

is it possible to produce the following format in QlikView?

I have tried several things without luck.  Any help appreciated

[sunny_talwar]

How exactly are you getting those numbers? May be if you can share your sample data with the logic behind the numbers, we might be able to offer some help

[Anonymous]

For each I have an expression Engagement Type I have separated into prospect and lead.

=if(#1='Book' and EngagementType='Lead',count(EngagementType))

[sunny_talwar]

I am looking for the raw data (dummy should work) in an Excel tile to create something similar for what you currently have

[Anonymous]

sample data

[sunny_talwar]

One more questions:

What is W, M, Y ? (Week, Month, Year?) How are you calculating these numbers? Most recent week, month, year?

[sunny_talwar]

Not sure, but is this what you want? Created this using Pivot Table

[Anonymous]

yes W M Y stands for week month year.

That looks good but are you able to add the week month as well?

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[sunny_talwar]

How do you calculate Week, Month, Year? Most recent?

[sunny_talwar]

May be this: