Hi All ,

In QlikSense Map ,

Dimension : Country 

Colors by Measure : Euro value .

I see that instead of (,) for cents i see (.) which gives a different meaning .

I try to change the settings (like euro denomination ) i dont see it .Any idea to overcome this ?

Regards,

Uma

Good day,
I would like to modify a macro to send a straight table data to a excel file rather than a csv file. The original, csv export has been working for a few years from what I can see.
In the below macro, the portion of the macro that creates the excel file in the correct folder works perfectly.

The problem comes in when I want to Quit QlikView (ActiveDocument.GetApplication.Quit). When I un-comment that statement and run the macro, the excel file is created but then QlikView hangs with the below error.
I appreciate your assistance with this. Thank you in advance.

sub Reorder_Report

'Reading the file save path:
set v = ActiveDocument.Variables("vPath")
vPath = v.GetContent.String

'Define the file name:
set v = ActiveDocument.Variables("vFileName")
vFileName = v.GetContent.String

'Add the reload timestamp:
SET v = ActiveDocument.Variables("vfiledate")
varDate = v.GetContent.STRING

'Initialize Excel object:
set XLApp = CreateObject("Excel.Application")

XLApp.Visible = true

'Add a Workbook to Excel file:
set XLDoc = XLApp.Workbooks.Add

set XLSheet = XLDoc.Worksheets(1)
XLSheet.Activate

set table=ActiveDocument.GetSheetObject("CH04")

'Copy content of this object:
table.CopyTableToClipboard true

'And paste into Excel
XLSheet.Paste

XLSheet.Name = "Re-Order Report"

set XLSheet = XLDoc.Worksheets(1)
XLSheet.Activate

'Define a Range for which formatting will happen
set TitleRange = XLSheet.Range("A1:P1")
TitleRange.Font.Size = 12
TitleRange.RowHeight = 20

set DataRange = XLSheet.Range("A2:P300")
DataRange.Font.Size = 10
DataRange.RowHeight = 15

Const xlCenter = -4108
TitleRange.HorizontalAlignment = xlCenter
TitleRange.VerticalAlignment = xlCenter

XLSheet.Range("A1").Select

XLDoc.SaveAs vPath+vFileName+varDate

XLDoc.close

XLApp.Quit

' Up to here the xlsx file is created in the folder
' As soon as I un-comment the below Quit, QV hangs.


' ActiveDocument.GetApplication.Quit

end sub

Hi all,

Which is the best object for creating freeze panes ? I am using straight table but my selection functionality is not working properly.

For Ex:

id .   name .      country .     ship to

23    rob            us                23456

23    bob            ca               23456

24    jack           us                4560

here is what i am doing

i want freeze only 1st field so i have given that field in dimension and remaining fields in expression ,but when i am selecting 23456(ship to) it should show 2 rows right but it is just showing the row in which ship to is selected i.e means 1st row .

Can any one help to figure this out?

Thanks in advance

i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.

what expression should i use?

thanks.

john doub

Hi Community,

I have a data like below from there I need values only if Seq is 1,2,3,4,5, not others. In the below example this seq is 2 times only .

Hi,

Why the following  SCRITP code is FAILING in this "IF" FUNCTION,

 IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1

ERROR:  Invalidad Expression

That IF function is located at the bottom.

Conversion_rates_mapping:
Mapping LOAD
 Action, 
 Conver_rate
 FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is CONVERSION_RATES);


[DATE_PRODUCTION]:
LOAD
    "Date",
    Action,
    Production,
    Production  *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
 FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is DATE_PRODUCTION);


[DATE_PRODUCTION_3]:
NoConcatenate
LOAD 
    "Date",
    IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
    Conversion_rates_mapping:
Mapping LOAD
 Action, 
 Conver_rate
 FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is CONVERSION_RATES);


[DATE_PRODUCTION]:
LOAD
    "Date",
    Action,
    Production,
    Production  *ApplyMap('Conversion_rates_mapping', Action) as SALES_CONVERTED
 FROM [lib://TEST APP/Conversion_rates.xlsx]
(ooxml, embedded labels, table is DATE_PRODUCTION);


[DATE_PRODUCTION_3]:
NoConcatenate
LOAD 
    "Date",
    IF(Action='Action1',SUM(SALES_CONVERTED)) as Sales_converted_Action1
   
Resident [DATE_PRODUCTION];
Resident [DATE_PRODUCTION];

We have year wise Contract Share% for 2018,2019. How to display the constant Contract Share % per year across the dimensions and KPIs in a pivot table 

Contract Share comes from an inline table in below format.. 

and key has been created Share_Year&'_'&Share_Month&'_'&upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

To Map the key in KPI table  i.e. Year([Ship Date])&'_'&Month([Ship Date])&'_'& upper(Plant) &'_'& upper(Carrier) as %Key_ContractShare,

Below is the screenshot which is showing wrong values for Contract Share %. Need help in correcting

The actual Contract shares are below

Dear Experts ,

Please help me variance calculation for Fiscal year / Fiscal Qtr / Fiscal month wise dynamically for selected two year.

Test data and my QVW is attached for your reference. 

Thanks a ton.

Best Regards,

Milind.

Hi All

How can I use the formula you giving in form of table.

Calc1 = Billed Revenue in Close Month [Jun only] / Total Billed Revenue of entire month [Jan-Dec]

I want to make 

| Month | Calc1 |

| May       | 0.289 |

| June     | 0.301 |

im using expression below but the calc1 shows 0 and not showing any dimension in table.

Expression: 

sum ({< OppForecast= {'1'},[SPM Close Month] = {'$(=Month([SPM Date]))'}>}[Est. Billed Revenue For Current Year])/ sum ({< OppForecast= {'1'},>}[Est. Billed Revenue For Current Year])

Dimension:

=Date([SPM Date],'MMM-YY')