topic Re: Adding List Box as Filter in QlikView

Adding List Box as Filter

navaneeth79 — Wed, 27 Sep 2017 08:20:49 GMT

Hi all,

my data for example

Month backlog Current

July 50 100

August 100 70

and I created a list box for month

Month

July

August

I want the output to be

Month backlog+current Current

July 150 100

when I select the july month in list box

Re: Adding List Box as Filter

hari8088 — Wed, 27 Sep 2017 08:26:42 GMT

May be like this..

Re: Adding List Box as Filter

mdmukramali — Wed, 27 Sep 2017 08:27:15 GMT

Dear,

Use Month as Dimension.

Expression1: =sum(backlog)+Sum(Current)

Expression 2: Sum(Current)

Thanks,

Mukram.

Re: Adding List Box as Filter

navaneeth79 — Wed, 27 Sep 2017 08:50:37 GMT

backlog and current are based on date filed for understanding I gave that example but my data doesn't have any backlog or current field. I will below give an apt example

ID DATE_SUBMIT DATE_RESOLVED

a 25/06/2017 10/07/2017

b 28/06/2017 11/07/2017

c 10/07/2017 10/07/2017

d 15/07/2017 20/07/2017

when I select filter as july I want the output as

Month Backlog+Current Current

July 4 2

Re: Adding List Box as Filter

mdmukramali — Wed, 27 Sep 2017 08:59:08 GMT

Hi,

You mean how many ID's Submitted and Id's Resolved in each Month,

what if any ID Submitted in June and Resolved in August do you want to count that ID when you select July or Not?

ID DATE_SUBMIT DATE_RESOLVED

E 25/06/2017 10/08/2017

Thanks,

Mukram

Re: Adding List Box as Filter

navaneeth79 — Wed, 27 Sep 2017 09:02:34 GMT

i want to calculate how many ids I resolved in the month and how many of ids of that particular month got resolved in that month only

Re: Adding List Box as Filter

navaneeth79 — Wed, 27 Sep 2017 09:03:58 GMT

in your example it should count in august