Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any option to be able to highlight multiple values in single pivot table without removing other values of the same pivot?
Hi,
it's not clear, can you share some mock data and expected output in excel format. it will easy for us to help u.
One way is as below:
I have filter of field which is used also used in pivot and when user select the values in the filter then pivot should display the selected values as highlighted and also retain non selected values.
e.g.
City |
Mumbai |
Pune |
Chennai |
Hydrabad |
Bangalore |
City | Population |
Mumbai | 1500000 |
Pune | 1600000 |
Chennai | 1260000 |
Hydrabad | 1556000 |
Bangalore | 1500056 |
I have pivot table which has city and population field. Now when user select Mumbai or Hydrabad then these 2 values gets highlighted along with retaining other values in same table. And the selection of values will be the user's choice.
Please find below example for your reference.
I hope this helps.
e.g.
City | Population |
Mumbai | 1500000 |
Pune | 1600000 |
Chennai | 1260000 |
Hydrabad | 1556000 |
Bangalore | 1500056 |
Hi,
do u want this color by user filter selection? or it just static then u can try like below
=if(match(City,'Hydrabad','Mumbai'),RGB(255,0,0),Black())
p.s; just add above code in your City dimension & measure as text color expression then u can get below o/p
another way u can add data island at back check this method
Dynamic colors in QlikView – Learn QlikView
Thanks,Deva
Hi Deva,
Thanks for the response.
I don't want filter for city. I just wanted to use pivot table where user has access to highlight city/population.
Looking forward for your kind response.
Thanks,
Swati
Hi Swati,
Please add the below expression to both DIMENSION, EXPRESSION --> Text color expression
= If(Wildmatch(Concat(DISTINCT(City), '|'), City ) and GetSelectedCount(City)>0, Red(),black())
Note : Please add the dimension filed to your expression using set analysis
Ex: sum({<City={'*'}>}sales)
Thanks
Sasi