topic Re: forward quote between month and year in QlikView

forward quote between month and year

Thu, 30 Jul 2015 06:11:39 GMT

Hi,

In the label part of one expression; i have to display Ex:Jul’15.

in label i have coded like: =month($(vjuly))&'''&'15'

but i could not get.

Pls help me dudes...

MayilVahanan — Thu, 30 Jul 2015 06:17:16 GMT

Try like this

=month(Today())&Chr(39)&Right(Year(Today()),2)

sasiparupudi1 — Thu, 30 Jul 2015 06:24:27 GMT

replace(Date(Today(),'MMM YY'),' ',chr(39))

Thu, 30 Jul 2015 06:26:06 GMT

hey mayil, i wanna fetch data from excel- which is in shared location.

in edit script;

i have wrritten;

LET Sharepoint_Path ='$(Include=$(include_path)Connections\connect_to_digital_SP.txt)';

and at loading; i used like:

load XXXX

FROM

[$(Sharepoint_Path)Digital%20Monthly%20Plan.xlsx]

(ooxml, embedded labels, table is Deposits);

it is throwing error...can u tell how to proceed?

Thu, 30 Jul 2015 06:27:54 GMT

wow nice way

MayilVahanan — Thu, 30 Jul 2015 06:57:13 GMT

Did you check the value in this "Sharepoint_Path ' is right or wrong?

Thu, 30 Jul 2015 07:43:07 GMT

s that is correct.

MayilVahanan — Thu, 30 Jul 2015 07:55:10 GMT

Could you please check the file name. And also check the error message in log file.

Setting -> Document properties -> Generate Log file.