Selection on ListBoxes

[#1]

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]

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

[#3]

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

[#4]

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 · Accepted solution]

Try this as your count formula:

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

[adamdavi3s]

did this solve your query?

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