topic Re: Comparing the values of two drill down groups in a if condition in QlikView

Comparing the values of two drill down groups in a if condition

sindhura — Sun, 10 Jan 2016 09:03:48 GMT

Hi,

I have two different sets of dates groups, namely G1 and G2. wherein these includes years, Months and Dates.

G1 (years) G2(years)

2007 2009

2008 2010

. .

2015 2015

According to my requirement I should display G1 as a filter in the dashboard and

some of my sheet objects(bar charts) uses G1 drilldown group as a dimension.

and one of my sheetobj(bar chart) requires G2 drill down group as a dimension.

But I need to display only Y1group's year as a filter and need to filter based on selections on G1"s year.

I tried with giving G1 drill down group as dimension and used conditional enable option by giving expression as

= if (GetCurrentField([G1]) <> GetCurrentField(G2]),[G2)

but it doesnt helps.

kindly suggest me

and could you please tell me what are the possible reasons that might lead to duplicate values in the report?????

Re: Comparing the values of two drill down groups in a if condition

Gysbert_Wassenaar — Sun, 10 Jan 2016 15:08:35 GMT

Try changing the expressions in the second chart that uses G2. For example sum(Amount) would become sum({<G1_Year=,G1_Month=,G1_Date=, G2_Year=P(G1_Year), G2_Month=P(G1_Month),G2_Date=P(G1_Date)>}Amount)

To make things easier you could create a variable vSet as {<G1_Year=,G1_Month=,G1_Date=, G2_Year=P(G1_Year), G2_Month=P(G1_Month),G2_Date=P(G1_Date)>}. And change the expressions to use that variable: sum( $(vSet) Amount)

Re: Comparing the values of two drill down groups in a if condition

sindhura — Sun, 10 Jan 2016 18:59:05 GMT

{<G1_Year=,G1_Month=,G1_Date=, G2_Year=P(G1_Year), G2_Month=P(G1_Month),G2_Date=P(G1_Date)>}.

In this expresssion G1_year means

can I use as Year field in G1 rightaway or the Groupname?

Re: Comparing the values of two drill down groups in a if condition

sindhura — Sun, 10 Jan 2016 18:59:37 GMT

{<G1_Year=,G1_Month=,G1_Date=, G2_Year=P(G1_Year), G2_Month=P(G1_Month),G2_Date=P(G1_Date)>}.

In this expresssion G1_year means

can I use as Year field in G1 rightaway or the Groupname?

Re: Comparing the values of two drill down groups in a if condition

sindhura — Sun, 10 Jan 2016 19:51:34 GMT

Thanks for the reply. The answer you gave works with another chart that will be placed in another sheet.

I need to implement in the first chart and I have to use G1 group for interaction but the chart has to calculate based upon G2 group