topic Selecting the data in QlikView

Selecting the data

Thu, 16 Oct 2014 11:52:16 GMT

Hi guys,

I have list of partners who suppose to sent me data every month. Unfortunately some of them doesnot.

So I have database where I have number of working days, of how long it took for partner to send in data and if data was not submited, database has 0.

I dont have any problem when I am working with the one month, but now I been asked to prepare quarterly report.

I made 3 buttons: Show all, Always submited, At lease one month not submimet.

The first buton I just clear the selection in Number of Working Days

The third buton selecting any month when data was not submited.

and the Second button I don't know how to make works. basicaly whenever there is a month when data was sumbited is pop up on the list, and goal is to show only those who never miss submition of the data. I was thinking to use formula "min" but dont know where to make analises in this case.

any idea?

Thank you

Re: Selecting the data

sivarajs — Thu, 16 Oct 2014 12:47:45 GMT

How do you capture whether the customer is submitted or not?

Are you creating any flag to store the value.If yes then you can check by combining flag and month column

Give some example how you are data is...

Re: Selecting the data

Thu, 16 Oct 2014 12:55:27 GMT

I have Validation form in word document which is complited every month by my team.

I created macro which capture data from those documents and updated the database. So in database I have column "Number of Working Days" if in the column is 0 that means this partner does not submit data.

Monthly reports works fine for me problem is with the quarterly report

Partner	DB Date	Number of Working days
a	01/07/2014	10
b	01/07/2014	0
c	01/07/2014	11
d	01/07/2014	13
a	01/08/2014	13
b	01/08/2014	14
c	01/08/2014	15
d	01/08/2014	13
a	01/09/2014	17
b	01/09/2014	18
c	01/09/2014	14
d	01/09/2014	17

Re: Selecting the data

Thu, 16 Oct 2014 12:56:02 GMT

Hi,

As you have mentioned you are capturing the number of days a partner took to submit data.

so you can check if there is no zero available for past 3 months then you can show that partner list.

Re: Selecting the data

sivarajs — Thu, 16 Oct 2014 13:12:25 GMT

Check this link to find missing data http://community.qlik.com/thread/6521

Through this you can check the customer who has not submitted.Create a column called flag to show customer submitted or not (y/n). If customer has all 'y' in all the month then consider as 'all submitted'.

Just try to create a sample qv and check

Re: Selecting the data

Thu, 16 Oct 2014 13:13:43 GMT

Please see below what I need in QV. thos 1 and 2 are the count of 0 in selected quarter.

So when I perss my button which has action to clear all i will receive below table.

Then if I will press button which will make selection in Field "Number of working days" String 0 then I will see only those

But when I press button to select "Number of Working Days" String ">0" then when ever there is month that we received data it will be shown as well. for example if July we got nothing and then Aug-Sep we recevied the data this Partner will be in the both tables. What I want is that if there was at least 1 month when partner doesnt submit data it should be shown only in list for the red indicator (action "Number of Working Days" String ">0")

Re: Selecting the data

Thu, 16 Oct 2014 13:14:41 GMT

Problem is that I dont want to have this flag for all months, but only for selected quarter...

Re: Selecting the data

Thu, 16 Oct 2014 13:26:02 GMT

I know that I sould check if there is no 0 and despaly those, my question is how;)