Welcome to Qlik Community

Hi All,

i need a chart calculation which is sum (sales) has to shown for latest 10 days by default if there is no date selection made. if any date selection done then show accordingly. attached the sample data. Please help. 

TIA

 Hi,

I tried to made Api Calls (Create App) to Qlink cloud account through postman and the result response was Ok. But, i was not able to view on them UI. Is it possible to push JSON data into Qlink cloud account through REST API ? I was unable to find documentation regarding the same and some help topics suggest it is not STABLE and may be changed in future. Can you please let me know how to proceed or any suggestions how to fix this issue ?

Thanks & Regards,

Chethan Y 

Hello Team,

I am not able to include this formula in Qlik sens.Please  can any one  help me out :

ToChar ( Original_XYZ_No, "0" ) + " "+ ToChar ( Original_XYZ_Date, "0" )

Thanks in advance

Regards

RK

Hi,

I am trying to load data the table from MySQL server with 21,924,639 rows like the following:

[sales_transactions]:
SELECT `business_date`,
	cashier,
	`check_closed`,
	`check_no`,
	`grand_total`,
	`net_sale`,
	`store_code`,
	`store_id`,
	`transaction_id`
FROM `xxx_master_of_the_house`.`sales_transactions`
//LIMIT 3000000
;

STORE * FROM [sales_transactions] INTO [lib://../SALES_TRANSACTIONS.QVD](qvd);
drop table [sales_transactions];

However, I keep running into this error message below.

Error: ERROR [HY000] [Qlik][MySQL] Query execution was interrupted, maximum statement execution time exceeded
Execution Failed
Execution finished.

 I have already increased the timeout session in QMC to 999 before loading the table.

CUSTOM CONNECT TO "provider=QvOdbcConnectorPackage.exe;driver=mysql;host=xx.xx.xx.xx;port=xxxx;db=xxx_master_of_the_house;SSLMode=PREFERRED;UseTrustStore=false;QueryTimeout=999;"

Is there any other way that I am able to load the data without exceeding the maximum statement execution time?

Hi

Is it possible to have the following (as in image) in Qlik Sense, I have seen similar designs in QlikView.

Where Sales Forecast Profit Loss are buttons or something similar and when you click on it, this will take you to another app and display the dashboard their.

Also how can you set the app to go directly to the dashboard rather than main page where it shows all sheets.

As we are using multiple data sources the apps are different.

Thanks

Hi,

I have requirement to do the looping until all the values in the column has changed to first value. Please find the below example sample data

Order no,Line item,High Line Item

345678,15,10

345678,20,15

345678,25,20

345678,30,25

For the second row high line item is 15  its is indirectly point to line item 15 is pointing to high level item 10 and the output for the second line higher line item should be 10 same for the others. I need to implement this logic on the huge data sets where there will be more number of line items

Expected output:

Order no,Line item,High Line Item

345678,15,10

345678,20,10

345678,25,10

345678,30,10

Regards & Thanks,

Chetan

Hi Guys,

Please let me know how to implement the below logic.

I need to have 2 listboxes as filter. First filter (a dropdown) has years 2019, 2020 and 2021 and second filter also a dropdown which has months in it (Jan to Dec). All these are static or harcoded values (using inline table) and not coming from any field association i.e. no date fields/columns are associated to these filters. The issue is when Iam selecting 2019 and then March, all the 3 years are selected for March and shown in the report, whereas I just need to show only March values for only 2019 in the report. How to achieve this?

Hola buen día,

Soy nueva, recurro a ustedes porque necesito que la siguiente expresión me traiga solo los últimos 90 días desde hoy. 

Le puse WeeKsAgo pero no estaría bien ya que me cuenta semanas completas donde pueden haber mas de 90 días.  También agregué Num(Today(0)-90) pero no me funciona para lo que quiero. 

COUNT (distinct{<[Opportunity.CustName],
State ={'REAP','TRMITA','TRMITP','TRMITR','VENCIDA','ACEP'},
Progress ={"40"},
[Opportunity.TransDate.autoCalendar.WeeksAgo]={0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15},
LoanProduct = {"Prendarios"}
>} [Opportunity.CustName]) 

Gracias!

I was just curious, as it comes up a lot, but is there an easier way to create a balance range than the script below? We also use an input box version where to enter the range you want, but then if we end up with too many calculated dimensions in a report using that input box, it really affects the performance of the report.  So, is there an easier function to take something like a balance and just say break it out in $100 increments as a new field? Look forward to hearing how others tackle this. 

IF(ACCT_BALANCE<=200,'<200',
IF(ACCT_BALANCE>=200 AND ACCT_BALANCE<=400,'200-400',
IF(ACCT_BALANCE>400 AND ACCT_BALANCE<=600,'400-600',
IF(ACCT_BALANCE>600 AND ACCT_BALANCE<=800,'600-800',
IF(ACCT_BALANCE>800 AND ACCT_BALANCE<=1000,'800-1000',
IF(ACCT_BALANCE>1000 AND ACCT_BALANCE<=1500,'1000-1500',
IF(ACCT_BALANCE>1500,'1500+'
))))))) AS BalanceRange