topic Re: specific data variable in QlikView

specific data variable

soniasweety — Tue, 02 Mar 2021 16:17:10 GMT

Hi All,

@Taoufiq_Zarra @MayilVahanan

i have field called Month year and data looks like below

jan 2019

mar 2019

feb 2020

may 2020

jun 2020

0ct 2020

jan 2021

feb 2021

may 2023

here i want to create a variable to show me that output of . Oct 2020 ( which is max month of 2020 year it should be dynamic and it should not change of any other selections )

can any one help on this?

Re: specific data variable

MayilVahanan — Wed, 03 Mar 2021 08:17:03 GMT

HI @soniasweety

May be try like below

=Date(Max({1<Year={$(=Max(Year))}>}Date))

<-- it will provide the Max Date based on selected year and not change based on any selections.

You can derive date based on MonthYear field with help of MakeDate function

Sample:

=Sum({1<Date={'$(=Date(Max({1<Year={$(=Max(Year))}>}Date)))'}>}sales)

Re: specific data variable

soniasweety — Wed, 03 Mar 2021 09:03:54 GMT

Hi @MayilVahanan Thank you. but i need result in text object.

cant we do like this?

last month <= today

last month in 2020

max (yearmonth)<2021

how can i use above cases here in front end?

Re: specific data variable

MayilVahanan — Wed, 03 Mar 2021 09:37:20 GMT

Hi @soniasweety

Hope you're data in date format not in text format.

In text box

last month <= today:

=MonthName(Max({<MonthYear={"<=$(=Today())"}>} MonthYear))

Last month in 2020:

=MonthName(Max({<Year={2020}>} MonthName))

for ignore selection, you can add 1

Re: specific data variable

soniasweety — Wed, 03 Mar 2021 09:51:11 GMT

=MonthName(Max({<MonthYear={"<=$(=Today())"}>} MonthYear)) this is giving me feb 2021

=MonthName(Max({<Year={2020}>} MonthName)) - this giving me null -

Re: specific data variable

MayilVahanan — Wed, 03 Mar 2021 10:00:21 GMT

I think, you don't have Year field. Can you try like below

=MonthName(Max({<MonthYear={"*2020"}>} MonthYear))