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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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])