I may be overthinking this so any guidance is appreciated. 

I have these tables

- Planned $ by salesperson # and Product Group

- Sales history which contains Customer #s, Products, but NOT Product Group

- Customer master which contains Customer #, and Salesperson #

- Product Master which contains Product # and Product Group

We have a Plan tab on the dashboard where they want to add "Product Group" to the selection group.

We are using linked tables in the scripts behind the dashboard for current data connections.  I can't figure out how to get these tables linked to summarize Sales $ by Product Group.

I know this probably not nearly enough information, but any help would be appreciated.

Hey guys, 

I have a QVD generator that is running 3 separate SQL queries from various databases. 
I'm using Qlik to generate a superset QVD, combining all three datasets. 
This is working, currently, to build my main QVD for it's corresponding front-end app. 

The downside that I'm trying to tackle now is that, due to the SQLs running consecutively in section order, the QVD generator is taking 3x longer than expected. I'm hoping someone has a solution for running these SQL queries in parallel such that the QVD generator does not take much longer than the longest query, instead of a SUM of each individual query run-time.  

Thanks.

**EDIT** Also trying to avoid 3 separate QVD generators. 😉

Hi All,

I am still new to Qlikview.

I'm trying to compare two dates to display either a "Y" or "N" based on whether they are the same. I have formatted both date fields, but I’m always getting "N" in the result.

I tried the DATE and FLOOR function to remove the timestamp from both fields:

DATE([RECORDED_TIME], 'MM/DD/YYYY') as Recorded_Date
FLOOR([RECORDED_TIME]) as Recorded_Date_Floor

DATE([SURGERY_DATE], 'MM/DD/YYYY') as Surgery_Date
FLOOR([SURGERY_DATE]) as Surgery_Date_Floor

Then, I applied the following calculation to compare the dates:
IF(Recorded_Date = Surgery_Date, 'Y', 'N')
IF(Recorded_Date_Floor = Surgery_Date_Floor, 'Y', 'N')

However, this still doesn't work as expected. Could someone please guide me and let me know if I'm making any mistakes here? Is there a sample or best practice I could follow to compare dates correctly?

Thanks in advance for your help.

Greetings!

I've been reading recently about the "V-Order write optimization" that apparently MSFT uses to expedite the reading of Parquet files in MSFT PBI and other Fabric tools. MSFT claims that Parquet files following this optimizations are 100% Parquet standard, but I also have found statements indicating that only MSFT tools can write files in "V-Order". Furthermore, it seems that MSFT Fabric Direct Lake mode depends on "V-Order".

So, can we generate "V-Ordered" Parquet files using Talend Data Fabric / Qlik Talend Cloud? Also, since QSE can also read Parquet files, I assume that Qlik Sense can read "V-Ordered" Parquet files without problems, but please confirm (I haven't seen any options for writing Parquet files using this option in the "store" command's help documentation).

Please tag me @diagonjope, so that I receive a notification of your response.

Thanks!

++José

I am migrating Qlikview app to Qliksense, I have many table charts with same dimensions and different expression. Can i create one table chart and create multiple buttons with different expression measure so that the one table filter out each time we use different button. Is it possible in qliksense?

Please help, thanks in advance. @qliksense Qlik Sense Business 

I have one big tables with order related fields 

in KPI i need to show sales by region 

I am showing sum of product sold by region

Master item  = sum({<region_name= { ‘Americas’}>} Dollar_value)

I  displaying this in graph where X axis is ( YEAR &'-'& Month) 

Y axis - Above master item , with 2 other master item 

now I need to add set expression where it shows all the months data except current month

i dont have full date but i do have columns(attributes) which gives me month and year separate

my month filed name is “Month” and year field is called “Year “

this is what i have tried but obviously it doesn’t work

sum({<

Month={MonthEnd('$(today()),-1')},

region_name= { ‘Americas’}

>} Dollar_value)

Hello everyone, in the attached table I cumulate the sales per material class in column kum.

So far, so good. It works. But when i add another dimension, the cumulation does not work any more.

I use the following formulas for the key figures:

hey guys, 

i am trying to figure out how to incremental load data to same qvd.

I am loading this script:

HAV_HATIVA_MAIN:
LOAD *
from [lib://עסקית/HATIVA_HAV/HAV_HATIVA.QVD](qvd);

LIB CONNECT TO 'DC_DWH';

HAV_HATIVA_NEW_DATA:

SQL SELECT "LOGICAL_DATE",
"SERVICE_ORDER_ID",
"ORDER_NUM",
"ORDER_SERIAL_NUM",
"SERVICE_ORDER_SOURCE_DESC",
"SERVICE_ORDER_TYPE_NAME",
"SERVICE_ORDER_STATUS_NAME",
"CUSTOMER_TYPE_NAME",
"SHEM_CHATIVA_BO",
"SERVICE_ORDER_CREATION_DATE",
"CUSTOMER_ID",
"DW_CUST_SUB_SEGMENT",
"TEUR_SHERUT_BI",
"MISSION_ID",
"NEW_VALUE_DESC",
"DATE_TECH",
"SHEM_MACHLAKA_BO"
FROM MAROUNSH."MS_PIPELINE_HAV_MAG";

Concatenate(HAV_HATIVA_MAIN)
LOAD *
Resident HAV_HATIVA_NEW_DATA;

drop table HAV_HATIVA_NEW_DATA;

store HAV_HATIVA_MAIN into [lib://עסקית/HATIVA_HAV/HAV_HATIVA.QVD](qvd);

I am getting this error:

Hi People,

A user with a professional license, keep getting the login window without any error message. 

It keeps happening from different computers as well.

In the QMC, I see that the license was used a week ago.

I deallocated it, and ReInstate, but it didn't help.

Any ideas?

Thanks in advance!