Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Aasir
Creator III
Creator III

Conditions on Unpivoted Column

I had below as column headers

Jul-23  Aug-23  Sep-23   Oct -23

Below are the values after unpivoting

Awm_0-1698899787216.png

But the below expression is not working

Sum({<[MUFW Clinic Volumes.Attribute field]="Jul-23">}[Volumes.Budget])
Why ?

Labels (4)
1 Solution

Accepted Solutions
Aasir
Creator III
Creator III
Author

This worked.
Sum({<[MUFW Clinic Volumes.Attribute field]={'Jul-23'}>}[Volumes.Budget])

View solution in original post

2 Replies
brunobertels
Master
Master

hi try with smple quote :

Sum({<[MUFW Clinic Volumes.Attribute field]='Jul-23'>}[Volumes.Budget])

Aasir
Creator III
Creator III
Author

This worked.
Sum({<[MUFW Clinic Volumes.Attribute field]={'Jul-23'}>}[Volumes.Budget])