Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vsap2000
Creator
Creator

Convert Text to Num

Hi,

I am trying to use Current Year flag ( values: 1 , 0), in selection bar extension of qlik sense as shown:

If(Iscurryr = 1, 'Curr','Not Curr').

list type = Field.

I want to show default as Curr, but initial selection area is grayed out saying Field is a calculated dimension, Initial Selection not supported.

How I can make it to work please let me know.

Thanks in advance.

-vsap2000

Labels (1)
2 Replies
treysmithdev
Partner Ambassador
Partner Ambassador

I would suggest this calculation be added to the script, so that you can use the resulting field in the extension. It will be faster and will overcome the limitation of not being able to use a calculated dimension (expression) as an initial selection.

Blog: WhereClause   Twitter: @treysmithdev
vsap2000
Creator
Creator
Author

Script part is handled by different division so it will be big route, if this possible in presentation worksheet that would be more viable.