topic Re: Help with idea in QlikView

Help with idea

Anonymous — Fri, 18 Oct 2013 19:44:36 GMT

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,

Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 19:51:05 GMT

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

Re: Help with idea

Clever_Anjos — Fri, 18 Oct 2013 19:52:26 GMT

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

Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 19:53:29 GMT

Can you upload a sample file?

Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 19:54:14 GMT

oops mis read what you need sorry

Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:01:50 GMT

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,

Re: Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 20:14:00 GMT

here is a sample file

Re: Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:29:42 GMT

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

Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 20:36:54 GMT

Have you tried my file

Re: Help with idea

javier_florian — Fri, 18 Oct 2013 20:36:57 GMT

Hi Vladimir,

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

Change TOTAL for ALL...

Regards,

JFlorian

Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:39:46 GMT

Yes, I did it. Didn't work for me

Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:45:32 GMT

Please see my attached file

Re: Help with idea

javier_florian — Fri, 18 Oct 2013 20:49:04 GMT

Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:51:29 GMT

It doesn't work. Please see below my attached file

Re: Help with idea

javier_florian — Fri, 18 Oct 2013 20:52:59 GMT

With your file, it work for me... What version do you have?

Re: Re: Help with idea

Anonymous — Fri, 18 Oct 2013 20:56:40 GMT

Please find the attached file

Re: Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 21:03:03 GMT

Hi Vladimir, you have the relative box ticked Untick it

Re: Re: Re: Help with idea

Anonymous — Fri, 18 Oct 2013 21:14:54 GMT

I doesn't work with calendar.

Please see the attached file. When you use {1} , you get wrong %

Re: Re: Re: Re: Help with idea

rustyfishbones — Fri, 18 Oct 2013 21:19:54 GMT

Hi Vladimir,

I have tested by adding a TOTAL bar, it seems fine when I make selections

See attached

Re: Help with idea

CELAMBARASAN — Fri, 18 Oct 2013 21:41:46 GMT

try with

Count([qID_15863_Purpose of Visit])

/ $(=COUNT({<[qID_15863_Purpose of Visit]=>} [qID_15863_Purpose of Visit]))