Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Partner
Partner

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.

Tags (2)
1 Solution

Accepted Solutions
morganaaron
Valued Contributor

Re: Only function with alternate states & dynamic number formatting

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

6 Replies
Partner
Partner

Re: Only function with alternate states & dynamic number formatting

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

Partner
Partner

Re: Only function with alternate states & dynamic number formatting

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
Valued Contributor

Re: Only function with alternate states & dynamic number formatting

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

Partner
Partner

Re: Only function with alternate states & dynamic number formatting

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

Do you have any idea for the issue 1?

Thank you

Partner
Partner

Re: Only function with alternate states & dynamic number formatting

Maybe is better to use the only like that:

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

or not?

morganaaron
Valued Contributor

Re: Only function with alternate states & dynamic number formatting

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!