topic Re: If expression current selection month < expression current selection month in QlikView

If expression current selection month < expression current selection month

Thu, 22 Jan 2015 11:20:36 GMT

Dear community,

I'm having troubles with creating a formula when a expression based of the current selected Month is greater then the same expression based of the current selected Month - 1 (previous Month), the object shows a green icon or a red icon.

The Icon with colors I can figure out, but Im stuck at the current month > previous month part.

This is what it approx. should look like, but cant seem to get the formula to work.

=If (Num((Sum({<Type={'A'}>}Project_Days_waiting)
/
Sum({<Type={'A'}>}Project_date_start)))
>
Num((Sum({<Type={'A'}>}Project_Days_waiting)
/
Sum({<Type={'A'}>}Project_date_start))) -previous month,'Green icon','Red icon'))

Obviously the -previous month code part is wrong, but thats my question...what is the correct code in this situation.

Regards,

Sijmen

Re: If expression current selection month < expression current selection month

Gysbert_Wassenaar — Thu, 22 Jan 2015 11:42:00 GMT

Depends on what kind of month field you have.

Maybe

=If(Sum({<Type={'A'}>}Project_Days_waiting)/Sum({<Type={'A'}>}Project_date_start)

Sum({<Type={'A'}>}Project_Days_waiting)/Sum({<Type={'A'}>}Project_date_start)

Sum({<Type={'A'}, Month={'$(=max(Month)-1)'}>}Project_Days_waiting)/Sum({<Type={'A'}, Month={'$(=max(Month)-1)'}>}Project_date_start),

'Green icon',

'Red icon'

)

Re: If expression current selection month < expression current selection month

Thu, 22 Jan 2015 11:50:20 GMT

Thanks for the reply Gysbert.

We use 'Peil_datum' as the dimension where users can select a month in a listbox.

So all I need to do is replace 'Month' with 'Peil_datum' in my situation?

Regards,

Sijmen

Re: If expression current selection month < expression current selection month

Thu, 22 Jan 2015 13:01:29 GMT

Solved this by creating 2 variables in the document and using the 2 variables in the expression.

vSelectedYearMonth Num(If( Max(Peil_Jaar_Maand) > Today(), Today(), Max(Peil_Jaar_Maand)))

vPrevSelectedYearMonth num((VSelectedYearMonth)-1)

Use this part in the expression.

{< Peil_Jaar = {$(=Year(VPrevSelectedYearMonth))} , Peil_Maand = {$(=Month(VPrevSelectedYearMonth))}

Regards,

Sijmen