Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
)
)
)
Could you show a capture or attach an application?
I think it is more or less what the problem
Can you share a sample app to look into if possible ?
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.
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
Hello Archana,
Could you repost this thread in Qliksense forum for a quicker help.
Thanks,
V.