topic Re: get two always in QlikView

get two always

soniasweety — Sat, 16 Nov 2024 21:25:37 GMT

Hi all,

Rubenmarin

@sunny_talwar

i have a field like quarter with values like 2018Q1,2018Q2,2018Q3,2018Q4,2019Q1

so whenever i open the dashboard i need to see latest two quarters as selected.

how to achive this?

output: 2018Q4,2019Q1 [ if 2019Q2 in the data the result will be 2019Q1 and 2019Q2] like dynamic latest two quarters

Thanks

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 11:51:09 GMT

documrnt settings -> trigers-> on open -> select in field ->

lets assume string is the field.

=MaxString({<string=-{"$(=maxstring(string))"}>}string) // this will give the second max string

=maxstring(string) / this will give the max string

Re: get two always

soniasweety — Tue, 12 Feb 2019 11:54:59 GMT

giving error in expression.

Re: get two always

soniasweety — Tue, 12 Feb 2019 11:56:51 GMT

atatching sample

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 11:59:40 GMT

@soniasweety wrote:
giving error in expression.

Well if your Quarters are string values this should work just fine. Did you change the field string to your quarter field? Can you please write your final expression here. I dont have the qlik license so would not be able to open it.

Re: get two always

soniasweety — Tue, 12 Feb 2019 12:02:52 GMT

your expression is taking the second higest quarter 😞 but i dont want that

i want latest two quarters that means 2018Q4 and 2019Q1 these are the latest two quarters to be selected in listbox by on open

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 12:11:10 GMT

Isn't 2018Q4 the second highest quarter? do you have future quarter listed as well?

Re: get two always

soniasweety — Tue, 12 Feb 2019 12:12:37 GMT

yes.

currently 2019Q1 is the max quarter 2018Q4 is the second max quarter.

so latest two quarters 2019Q1 and 2018Q4 to be selected.

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 12:26:29 GMT

=MaxString({<string=-{"$(=maxstring(string))"}>}string)    // this will give the second max string

=maxstring(string)    / this will give the max string

the above will do if you want the max and second max quarter

for latest and second latest you can try

=year(today()) & 'Q' & ceil(month(today())/3)

=year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3)

Re: get two always

soniasweety — Tue, 12 Feb 2019 12:34:52 GMT

thank you. but still its not working.

i need an single expression two select latest two quarters from the data
my data looks like below
Quarter
2018Q1
2018Q2
2018Q3
2018Q4 so now when i open the qlikview in listbox 2018Q3,2018Q4 should be selected.
for example 2019Q1 is added now the result should be 2018Q4 and 2019Q1
could you please attach your sample that you have tried?

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 12:50:39 GMT

='('  &  year(today()) & 'Q' & ceil(month(today())/3) '|' &  year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3)   &   ')'

Re: get two always

soniasweety — Tue, 12 Feb 2019 12:55:33 GMT

garbage error

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 12:57:23 GMT

My bad

='('  &  year(today()) & 'Q' & ceil(month(today())/3) & '|' &  year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3)   &   ')'

Re: get two always

soniasweety — Tue, 12 Feb 2019 12:59:36 GMT

No luck 😞 still its taking only 2018Q4

assume that i have data 2018Q1 ,2018Q2,2018Q3,2018Q4 ......... the result 2018Q3,2018Q4

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 13:03:28 GMT

What about this

=chr(39) & '('  &  year(today()) & 'Q' & ceil(month(today())/3) & '|' &  year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3)   &   ')' & chr(39)

Re: get two always

soniasweety — Tue, 12 Feb 2019 13:05:52 GMT

Nothing selecting in listbox 😞

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 13:06:55 GMT

@soniasweety wrote:
No luck 😞 still its taking only 2018Q4

assume that i have data 2018Q1 ,2018Q2,2018Q3,2018Q4 ......... the result 2018Q3,2018Q4

Hey ,,, you said latest quarter so it should select 2018q4 AND 2019 Q1

If you need max quarter and second max quarter you have to use maximum expression i have asked you to use

Re: get two always

soniasweety — Tue, 12 Feb 2019 13:08:51 GMT

anything.. dynamically it should take max two quarters whatever the quarters present in the data.

i cant use for 2018Quarters seperatly and 2019Qurters seperately 😞

Re: get two always

pradosh_thakur — Tue, 12 Feb 2019 13:10:56 GMT

See.. there are two cases

maximum and second maximum quarter use

'('  & MaxString({<string=-{"$(=maxstring(string))"}>}string) & '|' &  maxstring(string)    &   ')'

latest and second latest quarter

'('  &  year(today()) & 'Q' & ceil(month(today())/3) & '|' &  year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3)   &   ')'

edit: replace string with your quarter field in first expression

Re: get two always

pradosh_thakur — Wed, 13 Feb 2019 05:44:56 GMT

Did you solve this . if yes then please close the thread.

If not then i am attaching the sample QVW as you have asked, I didn't have qv with me when you asked for a sample. Attached sample is using the expression i have asked you to use.

Thanks

Pradosh