Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
sindus123
Contributor III
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
Anil_Babu_Samineni

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
Contributor III
Contributor III
Author

Missing Count Details.pngsample data.png

Not applicable

Hi,

Hope this helps.

Not applicable

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

Anil_Babu_Samineni

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)
Kushal_Chawda

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.