Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to produce the following format in QlikView?
I have tried several things without luck. Any help appreciated
I guess you need to ignore selections in other date fields:
=Count({<%DateEmpFormAdded = {"$(='>=' & Date(AddYears(Max(%DateEmpFormAdded), - 1)) & '<=' & Date(AddYears(Max(%DateEmpFormAdded), 0)))"}, DateEmpMonth, DateEmpYear, DateEmpMonthYear>}EngagementType)
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
For each I have an expression Engagement Type I have separated into prospect and lead.
=if(#1='Book' and EngagementType='Lead',count(EngagementType))
I am looking for the raw data (dummy should work) in an Excel tile to create something similar for what you currently have
sample data
One more questions:
What is W, M, Y ? (Week, Month, Year?) How are you calculating these numbers? Most recent week, month, year?
Not sure, but is this what you want? Created this using Pivot Table
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/>
How do you calculate Week, Month, Year? Most recent?
May be this: