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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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.