topic Re: Variable in QlikView

Variable

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

Hi All,

I have a text boject and within its layout i have a condition which is

Max({Dashboard} Date_MonthNumber) <= Max_Lead_YearMonth

and i checked the variable ( Max_Lead_YearMonth) which is further defined as below

=Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)

it works fine till janaury 2017 but when i slecet Feb 2017 the text object dissapears

Can someone please suggest if i need to make some changes to the variable ?

it should not dissappear if i select any month . can change the variable like below ?

=Year(max({1} MAX_Lead_Date)) * 100 +Num(Month(max({1} MAX_Lead_Date)))

Thanks in advance

Re: Variable

sunny_talwar — Mon, 27 Feb 2017 11:05:41 GMT

What exactly are you trying to do here? Would you be able to share a sample? what are the values for Date_MonthNumber and its format and values for MAX_Lead_Date and its format?

Re: Variable

ramasaisaksoft — Mon, 27 Feb 2017 11:09:38 GMT

Hi John,

Can you elaborate properly?

we didn't understand your issue properly.

Re: Variable

smilingjohn — Mon, 27 Feb 2017 11:11:51 GMT

Hi Sunny ,

My requirement is it whould even appear for current month .. and below is the format of the date

Re: Variable

Anil_Babu_Samineni — Mon, 27 Feb 2017 15:31:08 GMT

Confused, Fully not understand your intend to show

=Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)

Assume You have Dates like 01-01-2016 To 26-02-2017

From here When you use Year here Values come up like 2016 & 2017. This case, For which year you calculating with 100 in Text object. And Month() function returns only Name. I am not sure i understand here due to string and Number are involved on your Expression

Re: Variable

sasiparupudi1 — Tue, 28 Feb 2017 08:19:12 GMT

change the variable

from =Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)

Date(MAX_Lead_Date,'YYYYMM')

hth

Sas