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: 
rnepla83
Partner - Creator
Partner - Creator

Only function with alternate states & dynamic number formatting

Hi community,

I need your help to solve two issue that you can find the explanation of the Problems into the attached file.

Is too long to explain the problem here (is more easy with an attached).

Can someone solve and attach back?

Thanks a lot.

Best regard.

Paolo.

1 Solution

Accepted Solutions
morganaaron
Specialist
Specialist

Try this for Issue 2 - haven't extended to try with multiple values though.

View solution in original post

6 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Paola,

Question 1.

you could create 2 copies of the table, one with ITA formatting and the second with ENG, an use conditional show set via the 2 buttons

See attached.

Andy

rnepla83
Partner - Creator
Partner - Creator
Author

Thanks anyway Andrew,

is not possible to follow such way, in my final qvw there will be more than 600 charts, if i will duplicate each object will be 1200 charts to manage.

Impossible

morganaaron
Specialist
Specialist

Try this for Issue 2 - haven't extended to try with multiple values though.

rnepla83
Partner - Creator
Partner - Creator
Author

Really Amazing, ijust have to check if will work with multiple values

Do you have any idea for the issue 1?

Thank you

rnepla83
Partner - Creator
Partner - Creator
Author

Maybe is better to use the only like that:

=If(GetSelectedCount([Program Description], false(), 'set1') =1, Only({set1}[Program Description]))

or not?

morganaaron
Specialist
Specialist

Yes - sorry had forgotten that the object wasn't in the alternate state. Unsure about 1, switching the number panel to expression default doesn't seem to allow the interpretation to differ for what the thousand separator is. May be a bug, may just be standard behaviour, afraid I don't know!