topic Re: Missing Count Details in QlikView

Missing Count Details

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

Hi All,

Please help me on below requirement.

1. I need to Create two buttons i.e StatusOk and Status NotOk .

StatusOk button which displays the count of status for selected continent from attached sample.

Status NotOk button should display the count of missing records for the selected continent based on the date.

2.On the selection of StatusOk button it should navigate to the detail table which should display the respective records for the selected continent. and when we click on Status NotOk button it should display the missing records(i.e for Continent Asia missing record is 1 on 20170302)

For continent Asia the StatusOk is 11 and Status NotOk is 1( because for date 20170302 segment A the region south is missing )

for continent Europe the StatusOk is 12 and Status NotOk is 0

Continent	Segment	Region	Date	Status
Asia	A	North	20170301	1
Asia	A	South	20170301	1
Asia	B	North	20170301	1
Asia	B	South	20170301	1
Asia	C	North	20170301	1
Asia	C	South	20170301	1
Europe	A	North	20170301	1
Europe	A	South	20170301	1
Europe	B	North	20170301	1
Europe	B	South	20170301	1
Europe	C	North	20170301	1
Europe	C	South	20170301	1
Asia	A	North	20170302	1
Asia	B	North	20170302	1
Asia	B	South	20170302	1
Asia	C	North	20170302	1
Asia	C	South	20170302	1
Europe	A	North	20170302	1
Europe	A	South	20170302	1
Europe	B	North	20170302	1
Europe	B	South	20170302	1
Europe	C	North	20170302	1
Europe	C	South	20170302	1

Thanks in advance

Re: Missing Count Details

Anil_Babu_Samineni — Thu, 20 Apr 2017 05:39:30 GMT

Confusing to me, Can you share output needs while you click the two buttons. What is the output if you select StatusOk and What if you slect Status NotOk

Re: Missing Count Details

Anonymous — Thu, 20 Apr 2017 06:30:22 GMT

Re: Missing Count Details

Thu, 20 Apr 2017 07:21:40 GMT

Hi,

Hope this helps.

Re: Missing Count Details

Thu, 20 Apr 2017 09:02:59 GMT

Hi,

I am assuming that there will be a filter of Continent.

Made 2 buttons of Status Ok and Status NotOk and made 2 text boxes for respective button:

Variable1=GetFieldSelections(Continent)

Status NotOk(Textbox Expression)=count({<Continent={"$(Variable1)"},Date_1={'20170301'}>}Status)-count({<Continent={"$(Variable1)"},Date_1={'20170302'}>}Status)

StatusOk(Textbox Expression) =count(Status)

Regards,

Sanya Chauhan

Re: Missing Count Details

Anil_Babu_Samineni — Thu, 20 Apr 2017 10:47:23 GMT

Can you check may be this you are looking?

Re: Missing Count Details

Kushal_Chawda — Thu, 20 Apr 2017 13:54:32 GMT

Hi kavya,

I have already replied to your question on below link. Please check on that.

Re: Help on button creation‌

Please don't create the duplicate threads. It is hard to refer.