topic How to display MonthYear value based on selected value in straight table in QlikView

How to display MonthYear value based on selected value in straight table

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

Hi friends,

i am facing one issue in straight table i.e. i have a table with mutiple columns. iam giving sample table below:

LOAD * INLINE[

MonthYear,Values

202001,2

202002,5

202003,6

202004,3

202005,6

202006,7

202007,5

];

here my question is if i select value it should display that selected month. for eg: if i select value is 6 related to monthyear 202005, it should display monthyear 202005 data in table not 202003 data like that i want to display yearmonth based on Value selection. can any one please help me on this.

Re: How to display MonthYear value based on selected value in straight table

dmac1971 — Thu, 05 Mar 2020 13:38:47 GMT

If you select 6 then you have to show both 202003 and 202005?

Re: How to display MonthYear value based on selected value in straight table

Anil_Babu_Samineni — Thu, 05 Mar 2020 13:40:50 GMT

Perhaps this? But, I wonder why it is needed to select on values which is data point?

If(GetSelectedCount(Values)>1, Sum({<MonthYear={"$(=Date(Max(MonthYear),'YYYYMM'))"}>} Values), Sum(Values))

Re: How to display MonthYear value based on selected value in straight table

shabarish0587 — Thu, 05 Mar 2020 14:03:50 GMT

HI Dmac,

I want to show only one selected value Monthyear.

Re: How to display MonthYear value based on selected value in straight table

shabarish0587 — Thu, 05 Mar 2020 14:07:26 GMT

HI Anil,

Thanks for your Reply. is it possible to write this condition on dimension level? because this value is linked with other sheet table. when i click on any value from table1 it will navigate to table2 and displays selected value Monthyear data.

Re: How to display MonthYear value based on selected value in straight table

Anil_Babu_Samineni — Fri, 06 Mar 2020 06:59:42 GMT

May be this?

=If(GetSelectedCount(Values)>1, Aggr(Only({<MonthYear={"$(=Date(Max(MonthYear),'YYYYMM'))"}>} Values), Values))