topic Re: Selection on ListBoxes in QlikView

Selection on ListBoxes

Wed, 10 Aug 2016 10:59:48 GMT

Hello Professionals,

I have two dates

Date 1: Selection on one Date and output (ListBox 1)

A - 50
B - 25
C - 30

Date 2: Selection on second Date and output(ListBox1 + ListBox 2)

A - 48
B - 23
C - 26

Output Required: Selection on Date1 and Date 2

A - 50
B - 25
C - 26 (Second date selection should apply on only value C)

Please let me know the approach how to achieve this.

adamdavi3s — Thu, 11 Aug 2016 07:22:52 GMT

I am afraid you haven't really given us much to work on here.. can you explain further or provide a sample dashboard?

Thu, 11 Aug 2016 09:10:21 GMT

Hi Davis,

I have attached the sample Source table along with expected and required results. Please have a look and thanks for responding.

Regards

Ram

Thu, 11 Aug 2016 10:34:48 GMT

Hi Davis,

Currently I am using QlikView Personal edition, can't open the other user .qvw files. Could you please explain in without the qvw file.

Regards

ram

adamdavi3s — Thu, 11 Aug 2016 12:04:26 GMT

Try this as your count formula:

=if(Environment<>'Production', count({<[Deployed-Month]-=>} [Ticket Number]),count([Ticket Number]))

adamdavi3s — Tue, 16 Aug 2016 06:20:53 GMT

did this solve your query?

If so please don't forget to choose helpful or correct answers