topic Represent NA in a Bar Chart in QlikView

Represent NA in a Bar Chart

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

hi there,

Actually i am using a DB where for a column i can have possible values as 0,1 and Blank. I can show sum of these values in a Bar Chart over a dimension. Now the question is I want to show another bar in the same chart that will show NA for blank values on the same dimension.

eg.

Load * inline

[

name,errors

A,2

B,3

A,Blank

]

Can anyone please help me out here..??

Also I have another question. Here i am trying to calculate %share for an individual from same column, so Column NPT has nu. of production hours. When i calculate % for A it will be sum(NPT)/sum(NPT). now the problem is it always show 100% whenever i select a person's name in filter and i understand the reason that it filters out other values as well. Is it possible to store total of NPT column seperatley and then i can use it to calculate percentage share of each individual..? I am trying this on frontend. Any help/suggestion will be appreciated.

eg,

Name,NPT

A,2

B,2

ideally share should be 50% for both but i am getting 100.

Thanks

Sagar

Re: Represent NA in a Bar Chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 07:45:39 GMT

What are you expecting from given data set

Load * inline [

name,errors

A,2

B,3

A,Blank ];

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 07:50:59 GMT

Anil I want my chart to represent 3 columns where it should print 2,Blank with A on xaxis and only 3 with B on x axis.

Re: Represent NA in a Bar Chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 07:54:28 GMT

In chart, 3 columns??? Will you able to draw on paper and share?

Re: Represent NA in a Bar Chart

datanibbler — Mon, 10 Jul 2017 07:57:13 GMT

Hi sagar,

blank spaces - no value - in an Excel sheet are a bit tricky to display - you will have to use an auxiliary formula in Excel to display something whenever there is a BLANK in that column - or try to load that with an IF_formula like

>> IF(LEN(TRIM([field])=0, 'A', 'B') <<

in QlikView and then check whether the count is correct - whether all the blank spaces in the column have been correctly identified by QlikView.

HTH

Best regards,

DataNibbler

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 07:59:07 GMT

I hope you can relate to this..Where i have values percentages are calculated but where we have blanks for a process it shows NA

Re: Represent NA in a Bar Chart

Anil_Babu_Samineni — Mon, 10 Jul 2017 08:02:38 GMT

Does it mean, you want to remove NA from above image. i am sorry for that. Will you able to provide sample application

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 08:04:51 GMT

Anil i want to keep it. As of now i am not able to show NA in bar chart. The chart i have provided above is made in excel not qlikview. o just wanted to show the example.

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 08:07:44 GMT

Hi Hofmann,

My requirement is to show NA in bar chart..

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 08:10:12 GMT

Also can you please revert back to my second question..??

"I have another question. Here i am trying to calculate %share for an individual from same column, so Column NPT has nu. of production hours. When i calculate % for A it will be sum(NPT)/sum(NPT). now the problem is it always show 100% whenever i select a person's name in filter and i understand the reason that it filters out other values as well. Is it possible to store total of NPT column seperatley and then i can use it to calculate percentage share of each individual..? I am trying this on frontend. Any help/suggestion will be appreciated."

Re: Represent NA in a Bar Chart

vinieme12 — Mon, 10 Jul 2017 08:10:23 GMT

please post some sample data

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 08:22:19 GMT

Processed By	Processing Time (Min)	QC Time (Min)	SumOfVolume	delay	Exempt	SumOfQC Count	SumOfInternal Error	SumofExternalError
Tapan Sharma	419	231	25	5	5	12	0
Tapan Sharma	1095	540	24	5	5	24	0
Tapan Sharma	905	250	12	5	5	5	0
Tapan Sharma	58	5	5	5	0
Tapan Sharma	40	2	5	5	0
Tapan Sharma	1142	75	33	5	5	3	0
Tapan Sharma	1831	140	5	5	0

Here now i want to make a bar graph showing sumofQCCount, sumofinternalerror and sumofexternalerror.

what is happening is i am getting only 2 bars but i want if i donot have values for sumofexternalerror column NA should appear in chart.

i hope this makes it clear.

Re: Represent NA in a Bar Chart

vinieme12 — Mon, 10 Jul 2017 08:36:55 GMT

ok, but what are your dimensions? and will you have all 3 expressions in a single chart?

Re: Represent NA in a Bar Chart

sagar_vij99 — Mon, 10 Jul 2017 08:39:14 GMT

There is one more field Process That has different values like Coding,Issuance etc.