Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
robin_heijt
Creator
Creator

Select value not working with number

Hi,

 

I am using an extension to apply filters through the select value option.

My values are as followed:

1B, 1A, 2, 3B, 3A, 4A, 4B

When I add all of these to the select value function. All values get selected except "2".

When I export the data to excel, I also get the notification that there is something going on between all of them as the 1B 4A etc.. are recognized as text, whereas the 2 is recognized as a number.

 

What should I do to get the "2" selected as well in my select values function?

 

I am using truechart menubar as the extension.

2 Replies
nazaQ
Partner - Contributor III
Partner - Contributor III

Hi,
can you post a screen of your item configuration in truechart menubar?
Thank you
eduardo_dimperio
Specialist II
Specialist II

Try to transform all in string values