Help with idea

[Anonymous]

Hi community,

I have a bar chart.

I'd like when I click on any tag, I want to see only this tag with current percent( not 100%).

Create condition if(A='each tag', expression)

or somebody knows better idea how to show selected tag in the bar chart?

Regards,

[rustyfishbones]

you can use the AGGR Function

I made a video on youtube called

Qlikview RANK Function with Set Analysis by RFB 107

something like this AGGR(RANK(SUM({1}Sales)),A)

I think it's similar to what you want to do

[Clever_Anjos]

Change your expression to SUM(Sales)/ SUM({1}Sales)

[rustyfishbones]

Can you upload a sample file?

[rustyfishbones]

oops mis read what you need sorry

[Anonymous]

Hi,

I have  a bar chart with 1 dimension and expression

Count([qID_15863_Purpose of Visit])

/COUNT(TOTAL [qID_15863_Purpose of Visit])

When I click on any tags in the chart, I get this tag =100%.

I want to see this tag with right %.

Or you know how to show my selected tag other way.

For example: all tags one color, selected tag - other color

Thanks,

[rustyfishbones]

here is a sample file

[Anonymous]

It doesn't work

My dimension [qID_15863_Purpose of Visit] and expression

Count([qID_15863_Purpose of Visit])

/COUNT(TOTAL [qID_15863_Purpose of Visit])

I use the same variable

[rustyfishbones]

Have you tried my file

[javier_florian]

Hi Vladimir,

Can you try with SUM(Values)/SUM(ALL Values)?

Change TOTAL for ALL...

Regards,

JFlorian