Sum with Set analysis Issue

[davyqliks]

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.

[Anil_Babu_Samineni]

Try with double quotes and If that picks?

[davyqliks]

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

[PradeepK]

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.

[Anil_Babu_Samineni · Accepted solution]

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 

[davyqliks]

Oh my, thanks, never seen this but it worked with double quotes and wildcard:

Thank you so much... Awsome!

[PradeepK]

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..

[davyqliks]

Like this?

Thanks again.

Daniel