Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to display weekly count bars for client specific.
Each bar for one week so i need to display total 16 bars 4 for one client.
I have attached the sample .qvf anyone help on this.
Thanks,
Kumar
no semi colon is there,i have copied the same line below.
any how i got the count but now, i am struggling to get the custom colour can you help on it.
Dimension:
1. ValueList('15','12','13','19','6')
2. Week_group
Measure:
if(ValueList('15','12','13','19','6')='15',
count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_id={'15'}>}invitation_id),
if(ValueList('15','12','13','19','6')='12',
count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'12'}>}invitation_id),
if(ValueList('15','12','13','19','6')='13',
count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'13'}>}invitation_id),
if(ValueList('15','12','13','19','6')='19',
count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'19'}>}invitation_id),
if(ValueList('15','12','13','19','6')='6',
count({<weekstart={">=$(=date(max(weekstart)-35))<$(=date(max(weekstart)-7))"},DateType={'invitation'},client_name={'6'}>}invitation_id))))))
As data is confidential i have added the sample data, and i am working on server.
The data i working and attached is same but not original data.
Please help how can i add custom colour for above expression?
Hi Pramod,
pick your rgb code from Color Picker - ColorPicker.com
Use this to colour code:(as colour expression)
if( ValueList('15','12','13,'19','6') = '15', RGB(r,g,b),
if( ValueList('15','12','13,'19','6') = '12', RGB(r,g,b),
if( ValueList('15','12','13,'19','6') = '13', RGB(r,g,b),
if( ValueList('15','12','13,'19','6') = '19', RGB(r,g,b),
if( ValueList('15','12','13,'19','6') = '6', RGB(r,g,b)
)))))
I think this for client, i need the colors for week...
Hii,
PFA the resulted output.
Hope this is what you required.
Thanks,
Vignesh
Hi vignesh,
That's fine.
As you are taking the max of week it is displaying the data of last year because the week number of 2015 is less than 2014.
Can you please check with it
Hi
Yes irrespective of any years i have considered. So it will take the maximum week data.
If required , mention the specific year in set analysis.
Regards,
Vignesh