topic Re: Problem with date selection in QlikView

Problem with date selection

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have trouble with setanalysis.

I my QVW, there is possible to select a date from 3 List Box (Year, Month, Day).

I want to be abble to auto calcule the end of selection; if the user pick only a year i need to have the last day of this year in my set analysis like (31/12/YEAR Selected) with this format (DD,MM,YYYY).

If he pick YEAR / MONTH i need to have (28 or 29 or 30 or 31 (depend on month)/MONTH/YEAR).

if he pick the full date, i have no calcul to do.

With if formula i can do it, but can't use IF expression in set analysis... so i m stuck.

The if statement who work :

=if(IsNull(GetFieldSelections(YEAR)),

MaxString(CNT_Date),

if(IsNull(GetFieldSelections(Month)),

DATE(MonthEnd(MakeDate(Year,12))),

if(IsNull(GetFieldSelections(Day)),

DATE(MonthEnd(MakeDate(Year,Month))),

Date(MakeDate(Year,Month,Day))

)))

The expression i m trying to use :

=Count({<CNT_Contribution={11},CNT_Date={EXPRESSION}>}CNT_IdDoc)

Thanks to anyone who can help me.

Re: Problem with date selection

Anonymous — Tue, 16 Aug 2016 08:35:04 GMT

I would define a variable with your expression

so you could test yor Expression with a textobject and your variable if the Expression works fine

in your Chart you Need to define with set analysis

=Count({<CNT_Contribution={11},CNT_Date={'$(=yourvariable)'}>}CNT_IdDoc)

Re: Problem with date selection

Gysbert_Wassenaar — Tue, 16 Aug 2016 08:52:59 GMT

Use a variable vExpression.

vExpression:

=Date(

if(

IsNull(GetFieldSelections(YEAR)),

Max(CNT_Date),

if(

IsNull(GetFieldSelections(Month)),

MonthEnd(MakeDate(Year,12)),

if(

IsNull(GetFieldSelections(Day)),

MonthEndMakeDate(Year,Month),

MakeDate(Year,Month,Day)

)

,'DD/MM/YYYY')

The expression i m trying to use :

=Count({<CNT_Contribution={11},CNT_Date={'$(vExpression)'}>}CNT_IdDoc)

Re: Problem with date selection

Tue, 16 Aug 2016 12:47:05 GMT

Hi,

Thanks Gysbert and Rudolf about the help.

Have a good day both of you two