Value in one column remains constant while in other keep changing

[#1]

	MATCH
COUNTRY	PLAYED	WIN	LOST
Total	98	49	49
PAKISTAN	10	9	1
INDIA	11	7	4
ENGLAND	12	6	6
WEST INDIES	13	8	5
AUSTRALIA	8	3	5
NEW ZEALAND	9	4	5
ZIMBABWE	11	2	9
SRI LANKA	9	6	3
BANGLADESH	8	3	5
IRELAND	7	1	6

Is it possible in QlikView to have a chart in which the data under played remain the same(means static) while data under win & lost changes with certain criteria.

[senpradip007]

Please share the expected output with sample data.

[prma7799]

Please share some sample app with expected output.

[ankur_abhishek]

Hi Arshad,

Yes this can be possible by set analysis. You can calculate the played column by Set analysis using {1} identifier.

{1} is used to restrict the user selection .

For Example:

=count({1<[Field Name1] ={'xyz'}>}Field name)

[Kushal_Chawda]

you can use the below expression to not affect any other selection

sum({1}Played)

[#6]

Thanks Kushal! Issue resolved.

[#7]

The other issue is raised that if I want to know the total of any country it should be look like 

	MATCH
COUNTRY	PLAYED	WIN	LOST
Total	10	8	2
PAKISTAN	10	8	2

When I want to see total of all countries it should be like

	MATCH
COUNTRY	PLAYED	WIN	LOST
Total	98	52	46
PAKISTAN	10	8	2
INDIA	11	9	2
ENGLAND	12	8	4
WEST INDIES	13	8	5
AUSTRALIA	8	3	5
NEW ZEALAND	9	4	5
ZIMBABWE	11	2	9
SRI LANKA	9	6	3
BANGLADESH	8	3	5
IRELAND	7	1	6

My previous query was to freeze all the data in played column while win & lost keep on changing.

[Kushal_Chawda]

If you select any country you will get the result for that county and if you will clear country filter you will get the result for all country