topic Re: need help urgt in QlikView

need help urgt

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: need help urgt

Gysbert_Wassenaar — Thu, 30 Aug 2018 08:37:56 GMT

In the first chart use set analysis expressions to overrule the state selection. For example sum(amount) would become sum({<state=>}amout) if your state field has the name state.

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 09:38:07 GMT

hi suppose i have in first chart expression

count(DISTINCT{<Testing]={'Yes'},Year = {$(vMaxYear)}>}ID)

in the chart back ground color as

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

and in the second chart expression is as

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

and in the background color as

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

how to do

Re: need help urgt

Gysbert_Wassenaar — Thu, 30 Aug 2018 09:41:16 GMT

Do what?

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 10:08:27 GMT

I will explain you clearly

I have 2 filters

GB/GF and service lines

and i have 2 charts

with GB/GF and Service lines

If i click on 1st chart of GB,GF thecorrsponding chart will appear and aslo in the second chart Corresponding service lines will appear based on month wise data

now if i slect on RBWM it in firs filter the corresponding second filetr

also in the 1st cart(based on GB/gf) ad in the second chart rsolvings ervice line data will show

and in if i futhur click on second filter, the first chart should not reflect , it will show only RBWM data

here first graph aslo reflecting , ca i know how to not reflect the first hart , if i furthur click on second chart

in the first chart

the chart will be like below

Re: need help urgt

Miguel_Angel_Baeyens — Thu, 30 Aug 2018 10:12:37 GMT

As Gysbert mentioned, include the field you want to exclude in the aggregation function of the respective chart.

Perhaps based on your example above, something like

count(DISTINCT{<Testing]={'Yes'},Year = {$(vMaxYear)}, [Resolving Service Line] = >}ID)

Assuming the second listbox has such name.

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 10:13:24 GMT

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))

Re: need help urgt

Miguel_Angel_Baeyens — Thu, 30 Aug 2018 10:17:11 GMT

Apply as above: use the field behind the listbox "Resolving Service Line" in the second chart with the "=" and the right part empty, which means that it will ignore whatever selection you are doing in that listbox while keeping the selections from anywhere else.

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 10:22:03 GMT

not coming

please check my expressions as i have give above

Re: need help urgt

Miguel_Angel_Baeyens — Thu, 30 Aug 2018 10:33:12 GMT

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

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 10:47:38 GMT

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

secon chart

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

and in the background colour as

Re: need help urgt

qlikapple — Thu, 30 Aug 2018 10:48:53 GMT

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?

Re: need help urgt

Miguel_Angel_Baeyens — Thu, 30 Aug 2018 11:46:21 GMT

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