topic Re: Show the id's status in terms of active,inactive and both. in QlikView

Show the id's status in terms of active,inactive and both.

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

I have a data which contains two fields namely id and its performance date. Something like this:

I need to create a chart which shows me the status of the total count of id's getting activated, inactivated and both in a day wise manner.

Sample Output:

Here 2 id's are getting activated on 04-01-16, 1 id is getting inactive on day 7 and lastly '1 id is active - 1 id is inactive' on day 8.

I should show the differentiate the active/inactive/both id's in terms of the color's in the output.

Please provide a solution

Re: Show the id's status in terms of active,inactive and both.

isingh30 — Sat, 09 Jun 2018 15:58:03 GMT

Can you share your data in excel format?

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Sat, 09 Jun 2018 17:00:20 GMT

Hey. I have attached the dataset. Sheet1 contains my Id and performance date. Kindly provide the solution.

Re: Show the id's status in terms of active,inactive and both.

shiveshsingh — Sat, 09 Jun 2018 17:04:56 GMT

On what logic you want to calculate the count of active and inactive ids?on basis of colour?

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Sat, 09 Jun 2018 17:26:22 GMT

Yes. Green for active id's, red for inactive id's. if there is a combination of both active and inactive id's for the specific day then it should be separated by '-' (i.e active - inactive count, example: 2-1) and the color should be brown.

Re: Show the id's status in terms of active,inactive and both.

shiveshsingh — Sat, 09 Jun 2018 17:29:32 GMT

in your sheet1, how do you know that ID is active?

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Sat, 09 Jun 2018 17:38:01 GMT

min date and max date for the particular id. min date for the id refers to id active state and max date refers the inactive state.

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Sun, 10 Jun 2018 15:03:43 GMT

Just paste the code here once you're done.

Re: Show the id's status in terms of active,inactive and both.

MarcoWedel — Sun, 10 Jun 2018 21:16:34 GMT

Hi,

I guess one solution using your sample data might look like:

Can you provide the current result of your own efforts to identify the missing pieces?

Just paste it here once you're done.

thanks

regards

Marco

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Mon, 11 Jun 2018 05:01:28 GMT

Yes i require the exact result. please provide the code for this output to be executed in qlikview

Re: Show the id's status in terms of active,inactive and both.

MarcoWedel — Mon, 11 Jun 2018 18:38:28 GMT

Glad it's the correct result.

Can you share your current solution so we can see what bit is missing?

Re: Show the id's status in terms of active,inactive and both.

Anonymous — Thu, 14 Jun 2018 12:15:21 GMT

Hey Marco,

This is the result which i obtained. Plus I added some color format (Grey) for the days which are Saturday and Sunday. Thanks for sharing your result. It was helpful.