Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
sindus123
New Contributor III

Missing Count Details

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

ContinentSegmentRegionDateStatus
AsiaANorth201703011
AsiaASouth201703011
AsiaBNorth201703011
AsiaBSouth201703011
AsiaCNorth201703011
AsiaCSouth201703011
EuropeANorth201703011
EuropeASouth201703011
EuropeBNorth201703011
EuropeBSouth201703011
EuropeCNorth201703011
EuropeCSouth201703011
AsiaANorth201703021
AsiaBNorth201703021
AsiaBSouth201703021
AsiaCNorth201703021
AsiaCSouth201703021
EuropeANorth201703021
EuropeASouth201703021
EuropeBNorth201703021
EuropeBSouth201703021
EuropeCNorth201703021
EuropeCSouth201703021

Thanks in advance

6 Replies

Re: Missing Count Details

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sindus123
New Contributor III

Re: Missing Count Details

Missing Count Details.pngsample data.png

Not applicable

Re: Missing Count Details

Hi,

Hope this helps.

Not applicable

Re: Missing Count Details

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

Can you check may be this you are looking?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Missing Count Details

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.