Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

IAMDV
Honored Contributor II

Space (Character) problem in Set Analysis

Dear All,

I have an expression which works for all the dimensions expect one of them. The one which does not work have a space between two words like (example : Hard Coder). And rest all of them are single words and they work perfect! Please help me to solve this problem...

=Sum({1<Year={$(=($(vMaxYear)))}, MonthNumber={$(=($(vCurrentMonthNumber)))}, Usertype = {$(=(Usertype))}>} Sales)

Usertype : This is the field name which contains - Hard Coder.

I hope this makes sense. I am sure this must be simple but I can't get my head around this one...

TIA!

Cheers - DV

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Space (Character) problem in Set Analysis

Hello,

Try single quoting the usertype

Sum({1<Year={$(=($(vMaxYear)))}, MonthNumber={$(=($(vCurrentMonthNumber)))}, Usertype = {'$(=(Usertype))'}>} Sales)


Hope that helps.

2 Replies
MVP
MVP

Space (Character) problem in Set Analysis

Hello,

Try single quoting the usertype

Sum({1<Year={$(=($(vMaxYear)))}, MonthNumber={$(=($(vCurrentMonthNumber)))}, Usertype = {'$(=(Usertype))'}>} Sales)


Hope that helps.

IAMDV
Honored Contributor II

Space (Character) problem in Set Analysis

Miguel - Thanks so much! I had tried the same but in wrong place. I was trying like this...

Sum({1<Year={$(=($(vMaxYear)))}, MonthNumber={$(=($(vCurrentMonthNumber)))}, Usertype = {$(=('Usertype'))}>} Sales)

I am kicking myself now!

Thanks again for your help.

Community Browser