topic Re: single stack bar in QlikView

single stack bar

manoranjan_d — Thu, 07 Jul 2016 11:45:44 GMT

all,

below is my data

now i need the single bar chart of null and null values record count. how to achieve it?

where in the single bar it should differentiate the null and non null values

MK_QSL — Thu, 07 Jul 2016 11:55:49 GMT

Create a Flag inside Script something like this..

IF(IsNull(ID) or Len(TRIM(ID)) = 0, 'Null','NotNull') as IsNullFlag

Now you can use something like below

COUNT({<IsNullFlag = {'Null'}>}ID)

COUNT({<IsNullFlag = {'NotNull'}>}ID)

manoranjan_d — Thu, 07 Jul 2016 11:59:14 GMT

i m asking how to do it in chart of design.

varshavig12 — Thu, 07 Jul 2016 11:59:36 GMT

Something like this:

exp:1 =count({<ID={""}>}ID)

exp:2 =count(Total ID)-count({<ID={""}>}ID)

manoranjan_d — Thu, 07 Jul 2016 11:59:49 GMT

expression i can easily use it, but in the graph how to show it in single bar chart

manoranjan_d — Thu, 07 Jul 2016 12:00:18 GMT

yes can u attach the file for me

manoranjan_d — Thu, 07 Jul 2016 12:01:30 GMT

varsha can u attach the file for me

varshavig12 — Thu, 07 Jul 2016 12:01:44 GMT

Try this.

MK_QSL — Thu, 07 Jul 2016 12:06:14 GMT

Don't use any dimension..

use two expressions I have suggested

go to Style tab and select stacked..

manoranjan_d — Thu, 07 Jul 2016 12:07:58 GMT

so we should use stacked bar right in style ?

varshavig12 — Fri, 08 Jul 2016 03:29:41 GMT

Yes.

You got the desired output ?