topic Re: graph in qlikview? in QlikView

graph in qlikview?

Fri, 06 Mar 2015 13:48:35 GMT

HEY everyone!

I have 3 columns

in the antivirus_daysOld_update there are number of days that the laptop with the 00215F (for example)Netbios_name hasnt been updated

I want to have a graph (Camembert) when I can see the number of laptops that arent been updated more than 200 days old) and the one which the antivirus_daysOld_update is less than 200

Netbios_name serial_number antivirus_daysOld_update

002125F 41F598666 512

g459665 5463S556 50

The second question: I want to have in the graph VERSIONS OS the percentage instead of the number on laptop that has OS7 or OS XP.

P.S sorry I have a bad English

Re: graph in qlikview?

Anonymous — Fri, 06 Mar 2015 13:54:32 GMT

An example of counting those with >200 days:

=count({<antivirus_daysOld_update={">200"}>} serial_number)

modify it as your convenience.

Marc.

Re: graph in qlikview?

Fri, 06 Mar 2015 13:57:59 GMT

Thaaaaaaaaaaaanks

Re: graph in qlikview?

Fri, 06 Mar 2015 14:26:55 GMT

heeu it didnt work

there is a problem in the syntax I think

Re: graph in qlikview?

Fri, 06 Mar 2015 15:31:25 GMT

I wasnt clear in my question I want a graph (Camembert) who is divised into two things the numbers of laptops (which have (antivirus_daysOld_update >200 ) and the other part with the number of laptops who have (antivirus_daysOld_update<200)

that is not what I want :

Re: graph in qlikview?

awhitfield — Fri, 06 Mar 2015 15:34:23 GMT

The syntax is correct, but you need to ensure that the field name match your Exactly

=Count({1<AntiVirus_daysOldUpdate={">200"}>}Serial_number)

Re: graph in qlikview?

awhitfield — Fri, 06 Mar 2015 15:38:57 GMT

Re the second question:

Dimension = version os

Expression = Count(serial_number), tick relative

Number - tick show in percent %

Re: graph in qlikview?

awhitfield — Fri, 06 Mar 2015 15:54:36 GMT

Can you attached your actual QVW please?

Re: graph in qlikview?

awhitfield — Fri, 06 Mar 2015 16:06:41 GMT

See the attached example

Re: graph in qlikview?

Sat, 07 Mar 2015 11:47:23 GMT

i am so so so sorry but i cant open this look:

Re: graph in qlikview?

awhitfield — Mon, 09 Mar 2015 09:29:01 GMT

There are no dimensions in the bottom pie chart, but 2 expressions as follows:

=Count({1<AntiVirus_daysOldUpdate={">=200"}>}Serial_number)

=Count({1<AntiVirus_daysOldUpdate={"<200"}>}Serial_number)

Re: graph in qlikview?

MarcoWedel — Sat, 20 Jun 2015 00:09:00 GMT

Hi,

I already prepared an example when I noticed this is an old thread:

hope this helps ...

... someone

regards

Marco