Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

need help urgt

Hi i hav 2  charts

i have clicked on   1 chart , the 1st chart data wll be displaying and aslo 2 chart related data also displaying ,

then if i  want to drill down o 2 chart .

if am drillin down on 2 chart , the 1st chart dat hould not get reflectd, wat ever first i have clicked on the 1st  chart that as to get pop up

ex: i have sales on country wise on month wise

1st chart will be  countries wise

India, aregntina, canada based n month wise sales,

if i click on 1st chart india , the data will how up.

in the secnd chart , the states wise data will show .

Now my requirement is

if i go to second chart and click on statewise data,

the first chart inia wouldbe like that ony , it should not refelect  , how

12 Replies
qlikapple
Creator
Creator
Author

no not coming

in the 1st chart dimension i have kept as month andin the exprssion as

count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)

and in the background color as


=
If(GetSelectedCount(RES_GBGF_NAME)>0,
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)<=SUM({<Refline={'inbound'}>}Refvalue),rgb(117, 238, 7),
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)>SUM({<Refline={'outbound'}>}Refvalue),rgb(238, 24, 7), rgb(238, 237, 7)

)),
rgb(141,170,203))

secon chart

count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)

and in the background colour as

=If(GetSelectedCount(RES_SL_CI_NAME)>0,
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)<=SUM({<Refline={'inbound'}>}Refvalue),rgb(117, 238, 7),
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)>SUM({<Refline={'outbound'}>}Refvalue),rgb(238, 24, 7), rgb(238, 237, 7)

)),
rgb(141,170,203))

qlikapple
Creator
Creator
Author

the first chat if i click on the first and second will change

then furthur if i clisk on second filetrelated to second chrt , the corresponding first chart should not get changed ,how?

Miguel_Angel_Baeyens

Well, the expression is the same, so the filter to be applied in set analysis should be the same.