topic Re: help with arrow expression in QlikView

help with arrow expression

arusanah — Wed, 24 Aug 2016 02:12:26 GMT

i'm trying to show arrows next to my calc . I have Field1 field which has 100+ values , based on my date selection I want to compare current month number with previous month and show arrow based on changes between current and previous month. This is the expression I am using but it is not providing the results. Any help is appreciated

if(

(count({$<Field1=,

MonthYear={$(='"'&concat(distinct date(Addmonths

(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY') ,'","') &'"')} >} [Identifier]) > 0

OR count({$<Field1=,[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier]) > 0

// if ((count({$<MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')},Field1=>} [Recipient Identifier]))

// - (count({$<[Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"},Field1=>} [ Identifier])) = 0,

if(

(count({$<Field1=,MonthYear={$(='"'&concat(distinct date(Addmonths

(MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Identifier]) =

count({$<Field1=, [Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier])

),'resize horizontal icon',

if(

(count({$<Field1=,MonthYear={$(='"'&concat(distinct date(Addmonths

(MonthYear, -Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Identifier])>

count({$<Field1=, [Date]={">$(varMinSelectedDate)<=$(varSelectedDate)"}>} [ Identifier])

),'arrow down icon','arrow up icon'

)

Re: help with arrow expression

othniel2014 — Wed, 24 Aug 2016 02:59:39 GMT

Could you show a capture or attach an application?

I think it is more or less what the problem

Re: help with arrow expression

vishsaggi — Wed, 24 Aug 2016 03:32:57 GMT

Can you share a sample app to look into if possible ?

Re: help with arrow expression

jonathandienst — Wed, 24 Aug 2016 05:32:05 GMT

Put the calculation in expression 1, and then in expression 2:

=If(Column(1) >= 0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')

And set Representation on the Properties | Expressions tab to Image and adjust the sizing options to suit.

Re: help with arrow expression

arusanah — Wed, 24 Aug 2016 10:52:43 GMT

Jonathan,

I am using this in qliksense , how do we call one expression in another in qliksense . had it been Qlikview , we can do it but qliksense not sure how to do that

Re: help with arrow expression

vishsaggi — Wed, 24 Aug 2016 12:06:28 GMT

Hello Archana,

Could you repost this thread in Qliksense forum for a quicker help.

Qlik Sense Forums

Thanks,
V.