Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
asknyldz
Contributor III
Contributor III

Expression Error

Hi there,

My Expression is,

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Thats mean, Business should be New and Expanded.

I Click Renewal, why i see New and Expanded.figures in my data?

Thanks

qlik.jpg

1 Solution

Accepted Solutions
Nicole-Smith

It's because in the set analysis you're telling it to only look at New and Expanded.  If you want it to take into account your selections, you can use the P() function with it:

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}*P([BUSINESS])>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

View solution in original post

3 Replies
markodonovan
Specialist
Specialist

Hi Askin,

Could you upload the sheet or show the current selections ?

I assumed they are the same field.

Mark

Nicole-Smith

It's because in the set analysis you're telling it to only look at New and Expanded.  If you want it to take into account your selections, you can use the P() function with it:

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}*P([BUSINESS])>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

View solution in original post

asknyldz
Contributor III
Contributor III
Author

Dear Nicole,

Thats perfect solution is P()

Regards,

Askin