Welcome to Qlik Community

Hi,

As per requirement, we enabled ' Total ' in appearance of Pie chart and kept it in middle of the pie chart.

Which is showing the values according to filter selections but we dont want to show the 'total' text and respective of 'zero' values according to filter selections.

Request you to kindly let me know the solution and help me out on this.

thank you in advance.

Regards,

Vara

I have a dashboard showing two bar graph, one showing Current period and another showing prior period for a metrics. In the Number tab of chart property, I have given Symbol format as Liters, K liters.. upon selections, the user see scale difference in both charts where Current period has scale of K liters and the Prior period has the scale of Liters. Upon further analysis, I found that the Current period has a values  above 3500 liters and prior period has values below 3500 liters.

Can someone help me identify how qlikview demarcate the scale change for Liters to K liters to M liters?

Dear Qlikxperts!!

I'm working with June 2019 version of N-Printing. I have created a HTML report and want to bring the content to body

of the mail which is through. However the "Keep Source Format" option isn't working fine. I have provided background colour conditions for table objects which doesn't reflect in N printing output. Kindly share the necessary things to be done.

Also is it possible to create a NPrinting report with Excel format and while publishing insert it in the body of the mail?

Thank You!!

Hi - What would be the best approach or logic to use if I want to create a trend by adding dimensions to each group. 

For example:

Previous FY - Bar should only reflect "Previous FY" Data only

FY-2015 - Bar should reflect "Previous FY" + "FY-2015" data to create a trend

FY-2016 - Bar should reflect "Previous FY" + "FY-2015" + "FY-2016" data to create a trend

Hi Guys,

I am new in Qlik sense I want color of text background but there is no option in Qlik cloud  when browse this issue on google I found try to use Qlik sense extension. Can you please help me how to use Qlik extension how to download how to import it in Qlik sense cloud.

Hi All

I have below load script working fine :-

// Part 1 Load the inventory raw data for SOURCE indonesia  

INVENTORY:
LOAD
'TI' as SOURCE,
(@54:60T)*(@61:75T) as C_ONHAND_AMT
From $(vRAWPath)$(vFile263)(ansi, fix, no labels, header is 0, record is line);

// Part 2 Load the inventory raw data for SOURCE Singapore 

LOAD left (FileBaseName(), 4) AS TDSS_invc,
'TS' as SOURCE,
(@54:64T)*(@65:75T) as C_ONHAND_AMT,
Date((@286:296T), 'DD-MMM-YYYY') as INVC_DATA_TDSS
FROM $(vRAWPath)$(vFile253) (ansi, fix, no labels, header is 0, record is line);

// Part 3 Load the monthly exchange table

LOAD SOURCE,
Rate,
MonthName(date) as [SalesMonth], //Join on to sales table -> Dont change name
Rate_
FROM
Map_Rate_.xlsx
(ooxml, embedded labels, table is Sheet);

My Table need expression for compute amount base on latest exchange rate for June 15000.

I have Try :- Sum(C_ONHAND_AMT)*Rate , it display Null.

My question is how to compute 301,887,280 X 15000 ( 2020 June Exchange Rate )

My data model :-

Hope some one can advise me.

Paul Yeo

Hello all,

I have data of 4 year so I want to show data quarter wise .

For.eg 

In 4 year there are 16 quarters , I want quarters in this format shown as below :

Q1, Q2,Q3,Q4,Q5.....Q15,Q16 etc

Can anyone help me to get quarter in that format I have date field as in  DD-MM-YYYY.

Highly appreciate for any solution.

Regards,

Kavita 

Hello ,

Can someone please help on this. It's a bit urgent.

• We have installed Qlik Nprinting 20.0.2(February 2020) and Qlikview Desktop 12.40 versions respectively.
• From Nprinting, we are trying to generate the report by enabling Dynamic naming. The expected output report should be in format "ReportName_vMonthYear.xslx" (Example: Report123_May2018.xslx). 
• Here vMonthYear is the Qlikview variable which has the expression: =GetFieldSelections(Month)&GetFieldSelections(Year)
• But the actual report that is getting generated is not fetching the Qlik variable vMonthYear value. The output we are getting is Report123_-.xlsx (vMonthYear is coming as "-").
• The Qlikview variables with GetFieldSelections function is not working in Nprinting.

And also, We have observed that if the Qlikview variable has Static value (like hard-coded value), then that variable is getting passed to Nprinting and the Qlik variable in dynamic file name is getting generated Properly. But if the Qlikview variable is computed by making use of any Field then that value is not getting passed to Nprinting and the output is coming as "-" in the dynamic file name.

We have tried various options by creating the new variable in Qlikview and storing this vMonthYear value: 

• vTest=vMonthYear
• vTest=$(vMonthYear)
• vTest='$(vMonthYear)'
• vTest=$(=vMonthYear)

and passing this newly created variable (vTest) in Nprinting Dynamic file naming. But nothing worked out.

If someone has encountered this issue, Please help.

Thank You.