Data looks like this:

User selects Fiscal Year 2020-2021. The expression should then sum the sales for Dec & Jan of Fiscal Year 2019-2020, and return '$7'.

My (failed) expression currently reads:

<!--
if(Sum({<[Fiscal_Month]>}Sales)>0,
Sum({<[Fiscal_Year]={'$(v_FiscalPrevYear)'}>}Sales))
-->

Probably missing something small and simple! v_FiscalPrevYear simply stores the value of the prev fiscal year, based on fiscal year selection.

Thanks!

I have a table that is about 200 million rows. 60 fields are in that table.  I have several fields that I want to link to one dimension. I have done the whole create crosstab, and created the tables. The problem is I need to do it to several fields

Market1 Market2 Market3 Nextfield1 Nextfield2 Nextfield3 Vendor1 Vendor2 Vendor3 dropDate1 dropDate2 dropDate3
row1 Colorado Utah NewMexico BV MN EL AA BB CC 5/6/2020 9/20/2021 12/20/2021
row2 Montana Nevada Wyoming MS IE LW WN PO SN 1/15/2021 10/25/2020 2/25/2021

Each table was set up like below. I have done this with other projects and it worked fine, but those projects pulled in millions of rows. Not hundreds of millions. Its star schema is one main table, 200 million rows, approx 50 fields with four other tables around it with 200 million rows each. It takes about 10 minutes just to open it.

Market:

LOAD
[Trans Id], Market1 as [MarketCarrier]
Resident FactTable
WHERE not Market1 '-' or Len(Market1) > 1;

Join(Market)
LOAD
[Trans Id], Market2 as [MarketCarrier]
Resident FactTable
WHERE not Market2 like '-' or Len(Market2) > 1;

Join(Market)
LOAD
[Trans Id], Market3 as [MarketCarrier]
Resident FactTable
WHERE not Market3 like '-' or Len(Market3 ) > 1;

I had created separate tables from what others had done. The market had its own table, Nextfield1 had its own table, Vendor had its own table like shown below. But the problem is, there are 200 million rows in the dataset. And each (one time for main, one time for Market, one time for Nextfield1, one time for  Vendor1,  and one time for dropDate1 ) it has to pull in the 200 million rows. Just to pull in the 200 million rows, it takes Qlikview 2 hours. Last night this ran all night and barely finished by morning.

Is there a better way to do this that doesn't take up all of my resources? Also, this is only 10 days of data. I can't go less than that on the number of days. 

Thank you,

Martha

Hi @Lech_Miszkiewicz  @Ruggero_Piccoli  @Frank_S

I'm using QlikView Printing 16.9

My template is PPT with Table as inputs. 

am using QlikView pivot table everything working fine. but in the pivot table i am getting first row as empty i want to remove 

is there any option to hide the row?

As the image above suggests, I'm looking to create records for every possible product/store/month combination - where that combination doesn't exist - and insert NULL for the Sales amount.

I've looked at this document; https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394 but can't work out how it would apply to my data - as far as I can tell, this only deals with filling in values using peek.

All help greatly appreciated, thanks.

Hi, 

I'm trying to rank hierarchies and I'm trying to write dimension.

Level=1 Manager,Level=2 Manager Helper ,Level=3 Employee

if selected level 1 show me level 2 names. 

=if (LEVEL=2,if(LEVEL=1 and PRED=WORKNUM,NAME))

 its not work:(

please help

Hello to all,

I have a problem. I should connect to a web page that uses a JSON token to update a table.

The data I have available are the following:

$.ajax({
type: 'GET',
url: 'www.testurl.com/covid19/web/index.php?r=json%2Ftab2',
username: 'username',
password: 'password',
dataType: 'json',

Is it possible to connect to the tab2?

Thanks!

Hello folks,

All of sudden when we run the tasks they are failing on access point. Earlier, they used to run fine

Any ideas what could have gone wrong?

In the log I am seeing

“Error: Document open call failed. The document might require username and password.”

attached is sample log message:

(3/4/2021 2:50:19 PM) Information: Max retries:5

(3/4/2021 2:50:19 PM) Information: Attempt:01

(3/4/2021 2:50:21 PM) Information: Opened the QlikView Engine successfully. ProcessID=8124

(3/4/2021 2:50:21 PM) Information: Allocated QlikView Engine successfully. Current usage count=1 of 8 (of type non-reader). Ticket number=17.

(3/4/2021 2:50:21 PM) Information: Loading document "Test.qvw" (2409.76 Mb)

(3/4/2021 2:50:22 PM) Information: Loading. LoadTime=00:00:01.0047680

(3/4/2021 2:50:23 PM) Error: Document open call failed. The document might require username and password.

(3/4/2021 2:50:23 PM) Information: Attempted to load the document with data.

(3/4/2021 2:50:23 PM) Error: The document failed to open.