Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Feeling very silly right now but cannot get the simplest thing to work i have done so much.
Please can anyone tell me why i can sum TotalQty and add the dimension MergeFibre and get the breakdown but when i add a value from the MergeFibre Field 'OtherMaterials' as set analysis in the sum i get a zero on that line?
Thanks. I am gong blind looking at this, it makes no sense.
I never get this situation but i found something long back : https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824
Try with double quotes and If that picks?
Thanks for the answer,
But just tried like
Sum({<MergeFibre = {'OtherMaterials'}>}TotalQty)
Sum({<[MergeFibre] = {'OtherMaterials'}>}TotalQty)
Sum({<[MergeFibre] = {"OtherMaterials"}>}TotalQty)
and still zero. Have you seen this before.... it just makes no sense!.
Thanks Anil for taking the time to suggest
Daniel
Seems like you might have extra space or other chr in dim Field-Value.
Try using len() and find soo..
Your expression is fine.. Only reason it's showing zero is because it cannot find value you are assigning in Set.
I never get this situation but i found something long back : https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824
Oh my, thanks, never seen this but it worked with double quotes and wildcard:
Thank you so much... Awsome!
Just out of curiosity.. can you share your example with len(MergeFibre) ..
Of-course the wildcard match will work.. but interesting thing is to understand why simple Modifier assignment was not..
Like this?
Thanks again.
Daniel