topic Re: Dynamic windows title with Date variables and Date fields in QlikView

Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 02:42:13 GMT

Hi,

I have a table thats Title should change based on the selections of date. And I have DatePicker Calendar objects that is based on two variables vStart_Date & vEnd_Date. So I am using them in the table title(Below mentioned expression) to get the date range whenever the user is selecting a date range in the datePicker Calendar. But I have Invoice Year and Invoice Month list box as well so that the users could select them whenever they want to.

The Problem is, when they select Invoice Year or Invoice Month the Date range from the table title doesn't go away. It stays in the title even the if i select only Year say, 2015 or month January.

='Report ' &'('&''& vStart_Date & ' - ' & vEnd_Date&')'

Is there any logic i can add to the mentioned expression here to achieve to that point?

I would appreciate your help.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 02:46:52 GMT

It is doable, but what would you want to see if you:

1) select Invoice Year?

2) select Invoice Month?

Listing out all possibilities would help us determine what would be the best if statement that would help you achieve whatever you final goal is.

Hope that make sense.

Best,

Sunny

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 02:56:39 GMT

Hi Sunny,

Thanks for your quick response. If i select Invoice Year I would like to see only Invoice Year in the title.

For example , Report 2015 (if i select Invoice Year 2015) in the Title. Same goes for Invoice Month.

Again, If i select Year 2015 and Month January (As Invoice Month) i would like to see Report January 2015 in the title.

In this case the date Range(which is based on the variables) should not be displayed.

But when i select date range then only i would like to see the date range in the Title.

Like, Report (7/12/2015 - 5/11/2015) something like this.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 03:00:34 GMT

Got it, and what about the possibility of selecting multiple years and Multiple months? What would be the expected output in those cases? or that won't ever happen?

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 03:04:59 GMT

Try this if not possibility of multiple selection in year or month:

='Report ' &

If(GetSelectedCount([Invoice Year]) = 1,

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month] & ' ' & [Invoice Year], [Invoice Year]),

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month], & '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 03:05:03 GMT

Hi Sunny,

I know i am being a little greedy here! But it would be very helpful if it shows in the title if i select multiple Years and months.

Thanks a bunch! I really appreciate your responses.

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 03:10:25 GMT

Try this May be:

='Report ' &

If(GetSelectedCount([Invoice Year]) > 1,

If(GetSelectedCount([Invoice Month]) > 1, Concat([Invoice Month], ', ') & ' ' & Concat([Invoice Year], ', '), Concat([Invoice Year], ', ')),

If(GetSelectedCount([Invoice Month]) > 1, Concat([Invoice Month], ', '), & '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

If you select 2014 and 2015 -> Output: Report 2014, 2015

If you select Jan and Feb -> Output: Report Jan, Feb

If you select 2014 and 2015 and Jan and Feb -> Output: Report Jan, Feb 2014, 2015

Not sure if the formatting is something you would like, but I don't know what your user will be selecting and what formatting would be ideal for them to see.

I hope this make sense?

Best,

Sunny

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 03:10:29 GMT

Hi Sunny,

For some reason the expression is showing error when i copied that to Table window title.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 03:12:33 GMT

My bad try this:

='Report ' &

If(GetSelectedCount([Invoice Year]) = 1,

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month] & ' ' & [Invoice Year], [Invoice Year]),

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month], '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 03:23:23 GMT

Hi Sunny,

The expression is working now. When I select Invoice Year it shows the Invoice Year But when I select Invoice Year and Invoice Month together it doesn't show the Invoice Year and Invoice Month Together. Also if I select Multiple Years it Doesn't Show Multiple Invoice Years in the title.

Thanks for All your effort. Whatever i got still very helpful.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 03:25:40 GMT

Try this:

='Report ' &

If(GetSelectedCount([Invoice Year]) > 1,

If(GetSelectedCount([Invoice Month]) > 1, Concat([Invoice Month], ', ') & ' ' & Concat([Invoice Year], ', '), Concat([Invoice Year], ', ')),

If(GetSelectedCount([Invoice Month]) > 1, Concat([Invoice Month], ', '), '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

If you select 2014 and 2015 -> Output: Report 2014, 2015

If you select Jan and Feb -> Output: Report Jan, Feb

If you select 2014 and 2015 and Jan and Feb -> Output: Report Jan, Feb 2014, 2015

Not sure if the formatting is something you would like, but I don't know what your user will be selecting and what formatting would be ideal for them to see.

I hope this make sense?

Best,

Sunny

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 03:34:24 GMT

Hi Sunny,

For some reason

The expression from your last comment is not working for the Year/ Month selections.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

avinashelite — Wed, 29 Jul 2015 04:49:27 GMT

try like this:

Insted of concat use the getfieldselections() function it should work

'Report ' &

If(GetSelectedCount([Invoice Year]) > 1,

If(GetSelectedCount([Invoice Month]) > 1, getfieldselections([Invoice Month], ', ') & ' ' & getfieldselections([Invoice Year], ', '), getfieldselections([Invoice Year], ', ')),

If(GetSelectedCount([Invoice Month]) > 1, getfieldselections([Invoice Month], ', '), '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 05:07:01 GMT

Hi Avinash,

I tried with the expression you mentioned here but if i select Invoice Year list box it doesnot show anything.

The expression Sunny T. provided in his earlier post works most part but the months selection & Multiple years and Months & Years combined doesnt work with that expression.

Here is Sunny T's expression:

='Report ' &

If(GetSelectedCount([Invoice Year]) = 1,

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month] & ' ' & [Invoice Year], [Invoice Year]),

If(GetSelectedCount([Invoice Month]) = 1, [Invoice Month], '(' & vStart_Date & ' - ' & vEnd_Date & ')'))

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 05:10:16 GMT

Hi Avinash,

One correction: Its working only for Multiple years selection. But not single years or months.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

avinashelite — Wed, 29 Jul 2015 05:10:24 GMT

can you please share your app??

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 05:10:44 GMT

Try this may be:

='Report ' &

If(GetSelectedCount([Invoice Year]) >= 1 and GetSelectedCount([Invoice Month]) >= 1, GetFieldSelections([Invoice Month]) & ' ' & GetFieldSelections([Invoice Year]),

If(GetSelectedCount([Invoice Year]) >= 1 and GetSelectedCount([Invoice Month]) = 0, GetFieldSelections([Invoice Year]),

If(GetSelectedCount([Invoice Year]) = 0 and GetSelectedCount([Invoice Month]) >= 1, GetFieldSelections([Invoice Month]),

If(GetSelectedCount([Invoice Year]) = 0 and GetSelectedCount([Invoice Month]) = 0, '(' & vStart_Date & ' - ' & vEnd_Date & ')'))))

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 05:12:10 GMT

That was my mistake, instead of >1 you need >=1

Re: Dynamic windows title with Date variables and Date fields

AH — Wed, 29 Jul 2015 05:30:36 GMT

Hi Sunny,

Thanks for the great help. I just cant thank you enough!

Year/Multiple Years both are working now. Only the months are not picking up. Except that everything is working.

Thanks,

Ahmed

Re: Dynamic windows title with Date variables and Date fields

sunny_talwar — Wed, 29 Jul 2015 05:37:24 GMT

‌Have you checked the Month field... May be I am calling it incorrectly ([Invoice Month]). May be in your database its called something else or the case is the issue? Not really sure what the issue is with month.