topic Re: Only function with alternate states & dynamic number formatting in QlikView

Only function with alternate states & dynamic number formatting

rnepla83 — Tue, 07 Apr 2015 14:31:35 GMT

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.

Re: Only function with alternate states & dynamic number formatting

awhitfield — Tue, 07 Apr 2015 15:05:02 GMT

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

Re: Only function with alternate states & dynamic number formatting

rnepla83 — Tue, 07 Apr 2015 15:10:22 GMT

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

Re: Only function with alternate states & dynamic number formatting

morganaaron — Tue, 07 Apr 2015 15:11:48 GMT

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

Re: Only function with alternate states & dynamic number formatting

rnepla83 — Tue, 07 Apr 2015 15:16:54 GMT

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

Do you have any idea for the issue 1?

Thank you

Re: Only function with alternate states & dynamic number formatting

rnepla83 — Tue, 07 Apr 2015 15:21:38 GMT

Maybe is better to use the only like that:

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

or not?

Re: Only function with alternate states & dynamic number formatting

morganaaron — Tue, 07 Apr 2015 15:43:38 GMT

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!