QlikView App Dev

[#1]

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

[CELAMBARASAN]

May be this

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

Using double quotes will compare both upper and lower case.

[nagarajupinnibo]

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?