topic Re: expression error in QlikView

expression error

NavinReddy — Wed, 14 Oct 2020 13:41:57 GMT

Hello All,

Please help me, how can i get 3 months values using below expressions. below expression is not workign for me. kindly help me if any modification to the expression.

MonthName(Date) as Metric_Month
vMaxDate=monthname(addmonths(max(Date),0))
vMaxDate2=monthname(addmonths(max(Date),-2))

=Count(DISTINCT{<Month=,Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}value_id)
&' ('&
num(num(Count(DISTINCT{<Month=, Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}value_id)/
Count(DISTINCT{<Metric_Month=, Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}Total <Metric_Month>value_id)),'###%')&')'

Thanks & Regards.
NR

Re: expression error

NavinReddy — Wed, 14 Oct 2020 18:54:03 GMT

Any suggestions please

Re: expression error

NavinReddy — Thu, 15 Oct 2020 10:28:49 GMT

Any suggestions please

Re: expression error

Kushal_Chawda — Thu, 15 Oct 2020 10:31:17 GMT

@NavinReddy can you share sample data with expected output?

Re: expression error

NavinReddy — Mon, 19 Oct 2020 08:26:00 GMT

Hi @Kushal_Chawda , sorry for my late reply, i have no access to share the sample data.

i want to disply 3 months value trend using below expression and variables, any expression edits.

variables:

vMaxDate=monthname(addmonths(max(Date),0))
vMaxDate2=monthname(addmonths(max(Date),-2))

Expression:

=Count(DISTINCT{<Month=,Metric_Month={">=$(=vMaxDate)<=$(=vMaxDate2)"}>}value_id)

Thanks & Regards,

Re: expression error

Kushal_Chawda — Tue, 20 Oct 2020 09:38:40 GMT

@NavinReddy you can create synthetic data in excel with required output. But looks like your expression should be like below

=Count(DISTINCT{<Month=,Metric_Month={">=$(=vMaxDate2)<=$(=vMaxDate)"}>}value_id)