Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Value in one column remains constant while in other keep changing

MATCH
COUNTRYPLAYEDWINLOST
Total984949
PAKISTAN1091
INDIA1174
ENGLAND1266
WEST INDIES1385
AUSTRALIA835
NEW ZEALAND945
ZIMBABWE1129
SRI LANKA963
BANGLADESH835
IRELAND716

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.

Tags (1)
7 Replies
senpradip007
Valued Contributor III

Re: Value in one column remains constant while in other keep changing

Please share the expected output with sample data.

prma7799
Honored Contributor III

Re: Value in one column remains constant while in other keep changing

Please share some sample app with expected output.

ankur_abhishek
New Contributor III

Re: Value in one column remains constant while in other keep changing

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)

Re: Value in one column remains constant while in other keep changing

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

sum({1}Played)

Not applicable

Re: Value in one column remains constant while in other keep changing

Thanks Kushal! Issue resolved.

Not applicable

Re: Value in one column remains constant while in other keep changing

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

   

MATCH
COUNTRYPLAYEDWINLOST
Total1082
PAKISTAN1082

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

   

MATCH
COUNTRYPLAYEDWINLOST
Total985246
PAKISTAN1082
INDIA1192
ENGLAND1284
WEST INDIES1385
AUSTRALIA835
NEW ZEALAND945
ZIMBABWE1129
SRI LANKA963
BANGLADESH835
IRELAND716

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

Re: Value in one column remains constant while in other keep changing

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