Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one dimension and three expressions
Dimesnion - if(DATE>='12/31/1980',YEAR)
Expression1 - avg({<NAME={'A'}>VALUE))/100
Expression2 - avg({<NAME={'B'}>VALUE))/100
Expression3 - avg({<NAME={'C'}>VALUE))/100
Now i want to hide YEAR in my chart for any quarter Q1,Q2,Q3,Q4 is null for those NAMES in the expression, then whole YEAR Should not be shown in my Chart.
Please let me know if there are any concerns
Thanks
Avinash
check out the expressions for countries you will get it
Hi,
Many thanks for your reply.
I am not getting correctly for the above solution. I have attached one file with inline table.
Please find the attachment
Thanks
Avinash jagan
first read the date in correct format..
SET DateFormat='MM-DD-YYYY';
Now use this expression in calculated dimension... and enable the 'Suppress When Value is Null'
if(DATE>'1-1-2011' and aggr(sum(if(len(ltrim(VALUE))=0,1)),YEAR)=0,YEAR)
Check if the attached is something you are looking for.
see the attached file...
Many thanks Sunny for your reply.
It is not working. May be my file data is wrong which i have attached. Could you please consider the first message as my requirement and can you help me on that message.
thanks
Avinash
Just so I understand, the output in the attached application is what you want, but when you apply the sample logic to your original application it doesn't give you the right output? Is that what is going on?
Hi Avinash,
If I understand correctly, as the data(VALUE) for Q2, Q3, Q4 quarters for 2013,2014 years is blank/NULL.
You have to omit those years from the dimensions. and you have to showcase only '2012' data.
If this is the case see my attachment in earlier post.
Yes Sunny i have applied your logic and i tried with your logic in changing the code to different scenarios but not getting the output.
Please help me on this.
Thanks
Avinash
I tried with your logic changing in the calculated dimension but not getting the output.
Please help me on this.
Thanks
Avinash