topic Re: get null rows based on one field value in QlikView

get null rows based on one field value

prasadreddy — Thu, 29 Mar 2018 08:55:06 GMT

Hi Team,

Can any one provide some help on my task.

I have a pivot table having three fields as below,

F1, F2 and F3 field having values A, B, C, D. I have given count(F1) as expression, output like came as below.

F1	F2	A	B	C	D
X1	Y1		1	1
X1	Y2	1	1	1	1
X2	Y1		1		1
X2	Y2		1	1	1
X3	Y1	1	1	1
X3	Y2	1	1	1	1

But, I want take only the rows associated to yellow cells, which means if the Field F3 Value A having null count, I want to display only those records in pivot table.

Expected out put like below:

F1	F2	A	B	C	D
X1	Y1		1	1
X2	Y1		1		1
X2	Y2		1	1	1

Thanks in advance.

Please provide any quick help.

Thanks,

Sampath.

Re: get null rows based on one field value

YoussefBelloum — Thu, 29 Mar 2018 09:10:12 GMT

Hi,

do you pivot the F3 field ?

I think when your F3 field Value A is null, it means that there is no A actually on that field, so it will load only B,C and D values, and you will have 3 columns when you pivot F3.

I'm I right ?

Re: get null rows based on one field value

prasadreddy — Thu, 29 Mar 2018 09:17:41 GMT

Hi Youssef,

No, in the first table I have given expression as Count(F1), the out put came as first table.

But I need to exclude the records if the Filed values 'A' has some count. and want to show only the A value associated to null.

Expecting the second table records.

Thanks,

Sampath.

Re: get null rows based on one field value

YoussefBelloum — Thu, 29 Mar 2018 09:26:58 GMT

Ok, try this:

count( {<F1=E({1<F3={'A'}>})>} F1)

Re: get null rows based on one field value

YoussefBelloum — Thu, 29 Mar 2018 10:01:32 GMT

Try this also please:

count( {<F3=E({1<F3={'A'}>})>} F1)