Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Delow is the dimension logic used in the straight table.But here i need to sort the month also as hardcode to Aug in the same expression.
Kindly let me know if it is possible.
Logic : =if([Sold Location] = '000', 'Goal', if([Sold Location] = '999', 'Company', if([Sold Location] = '888', 'District', if(match([Sold Location],'17','18','29','70','76','102','105','129'),[Sold Location]))))
In the above logic i need to include month as well.
Thanks..
Where are you using month in this calculated dimension? I am not seeing that above?
Hi Sunny,
The requirement is to include the month filter in the above calculated dimension .
Thanks..
I am not sure if this works, may be Sunny can come up with better way, mean while you can try this?
= IF( Month= 'Aug', Pick(Match([Sold Location], '000', '999', '888'), 'Goal', 'Company', 'District'),
IF(Month = 'Aug' AND match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location]))
Hi,
It means my calculated dimension needs to include month as well.
Thanks..
Hard code means this? Or else would you describe what is your intend to use this
=if([Sold Location] = '000', 'Goal', if([Sold Location] = '999', 'Company', if([Sold Location] = '888', 'District', if(match([Sold Location] ,'17','18','29','70','76','102','105','129'),[Sold Location], if(month(field) = 'Aug', 'Aug')))))
Yes..i need to hard code like this..but the logic is not working.
It's not filter the data for the month Aug and also it inserts an new column Aug in the table.
Thanks..
May be this:
=If(Month = 'Aug',
If([Sold Location] = '000', 'Goal',
If([Sold Location] = '999', 'Company',
If([Sold Location] = '888', 'District',
If(Match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location])))))
or
=If(Num(Month) = 8,
If([Sold Location] = '000', 'Goal',
If([Sold Location] = '999', 'Company',
If([Sold Location] = '888', 'District',
If(Match([Sold Location],'17','18','29','70','76','102','105','129'), [Sold Location])))))
Hi
Please post your sample qvw
Regards,
Gireesh.
Hi Sunny,
The locations were came out as null.
Thanks..