Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
MEDHA07
Contributor III
Contributor III

How to count non associated row if filter field value is null

Hi  All,

 

I have filed its genearyed values in oracle query

if group=001 then BI,

IF group -002 then PI

else ' ' as Type;

BI has 20 rows count

PI has 30 rows count

else condition means if it has null value in field it wil consider as '' it has 2 rows

in table without selection in filter pane i am getting 20+30+2=52 --Total

if i select BI getting 20 and PI means 30 but even i select BI i need to show null record count 20+2 =22

PI means 30+2 =32

if both means 52

i am unable to  count non associated value

in oracle query for that null filed record in measure  field has null and making that as zero .

Type  -->Filter

BI,

PD

above are displaying in filter pane in UI

In table  i need to count null field value 

I need to count pol and locid in count.that record has pol value and locid value

Measure:  count(aggr(count(pol+locid)),Pol,locid))

 

Labels (1)
0 Replies