Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Not applicable

using upper function in set analysis

Hi,

I am trying to use upper function in set analysis but I am not able to do this. Can you please guide me how to do this

sum({<upper([Leave Type]) = {'SICK'}>} [Hours Left])

The upper function in above expression is not working. Can you please tell me how do we use such functions in set analysis

Regards

Arif

2 Replies

Re: using upper function in set analysis

May be this

Sum({<[Leave Type]={"SICK"}>} [Hours Left])

Using double quotes will compare both upper and lower case.

Highlighted
New Contributor III

Re: using upper function in set analysis

Will the double quote fetch both the upper and lower case data and sum it? I don't think it works. Can you explain with more details?