Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please share the expected output with sample data.
Please share some sample app with expected output.
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)
you can use the below expression to not affect any other selection
sum({1}Played)
Thanks Kushal! Issue resolved.
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.
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