Hi,

My bundle load script is not working properly. My script is

Bundle

LOAD PlayerId,

          Image

FROM

D:\Qlikview\DataSource\Data.xlsx

(ooxml, embedded labels, table is Sheet3);

Image Column is Path of Image Store location.

When i reload this script Only PlayerId column will reloaded but image column is not.

- Regards,

Vishal Waghole

Hi,

In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting desired results.  I need to compare two more conditions  in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

The expression I am currently using is

sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

Any help would be highly appreciated.

Hi,

In my data model I have a date filed. I am using date Island to  and compare against the date in my data model. Using 'IF' I am getting desired results.  I need to compare two more conditions  in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

The expression I am currently using is

sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

Any help would be highly appreciated.

Hey guys,

I have a table like this: 

I want in to result as such:

Based on the top number of orders per region. So Office B has the most orders in Region 1 and so on.

I really want this as a dimension though since I want to use it for coloring a map later on and I have better possibilities when I use a dimenson

I am trying to list two numbers.  A. The amount of sales for SaleDate 2015 and B. The amount of credits with CreditDate in 2015.  I thought this would do it:  Sum( {1<CreditDate_RetailPeriod={SaleDate_RetailPeriod}>} CreditDet_NetSalesAmt), but that returns zero.  The idea is that I have a KPI which shows total sales and which the user may filter by SaleDate_RetailPeriod, but at the same time, I want to show total credits for the same retail period chosen by the user, but apply it to CreditDate instead of SaleDate and NOT show credits ONLY in the SaleDate period.  If I used two filters for the dates, that implies an AND, and I'm really looking for an OR on the two selections.

Hi  All

I am trying to open the dashboard in Debug mode but it is not opening and going back to UI only. Please suggest me what could be the reason.

Dear All,

I'm trying to extract data from MySQL database and I'm getting the below error.

Error: SQL##f - SqlState: 08S01, ErrorCode: 2013, ErrorMsg: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.17]Lost connection to MySQL server during query

The task was running fine and from last few days i am facing this issue.

Does anyone come across this kind of situation.

Thank you.

Regards,

Viresh

Hi,

I have a data set extracted from Active Directory with Logoff information of the users:

The format of this file is:

"This event is generated when a logon session is destroyed. It may be positively correlated with a logon event using the Logon ID value. Logon IDs are only unique between reboots on the same computer."""
"Information,13/06/2019 00.00.20,Microsoft-Windows-Security-Auditing,4634,Logoff,""An account was logged off."

Subject:
" Security ID: SYSTEM"
" Account Name: SYSTEM"
" Account Domain: NT AUTHORITY"
" Logon ID: 0x2BBE225A6"

"Logon Type: 9"

"This event is generated when a logon session is destroyed. It may be positively correlated with a logon event using the Logon ID value. Logon IDs are only unique between reboots on the same computer."""
"Information,13/06/2019 00.00.20,Microsoft-Windows-Security-Auditing,4634,Logoff,""An account was logged off."

Subject:
" Security ID: SYSTEM"
" Account Name: SYSTEM"
" Account Domain: NT AUTHORITY"
" Logon ID: 0x2BBE229D2"

"Logon Type: 9

repeated for each gorup of records (more than 500.000 rows, for only one day...), as per the attached sample (the original is .csv, but is not possible to upload it...):

I need to obtain these fields in a flat file :

TimeStamp, SecurityID, AccountName, AccountDomain, LogonID, LogonType

13/06/2019 00.00.20,SYSTEM,SYSTEM,NT AUTHORITY,0x2BBE225A6,9

13/06/2019 00.00.20,SYSTEM,SYSTEM,NT AUTHORITY,0x2BBE229D2,9

in order to monitor all the accesses by the users.

I tried with Transpose but this move ALL the rows to one line. What is needed is a Transpose limited to 8 rows each time a sort of a "reversed Crosstab", in order to create the a/m columns of fields, with the data, for each group of Records.

Many thanks for your help.

Best regards,

Giulio

Hi,

I am working on a graph where i have a bar and a line , one counts the transaction work done by a processor and the other one is sum(AvgProcessor) which depicts the if a tower has 4 processor then on average 1/4 processor work on a transaction.

Now when i see the total of avg processor based on Year it comes as average value not the total processor.

How could this  be resolved in QLikview.

Attached in the file for reference. Need quick guidance.

Thanks in advance.

Hi, I would like to categorize the revenue measure of the scatter graph to, 'below 500', 'between 500 to 999', 'between 1000 to 1499', 'above 1500'. however, the following expression doesn't work.

Aggr(Sum(if([Revenue]<=500, 'below 500',

If([Revenue]>=500 and [Revenue}<=999, 'between 500 to 999',

If([Revenue]>=1000 and [Revenue}<=1499, 'between 1000 to 1499',

If([Revenue]>=1500, 'above 1500', 'Others'))))))

Could any one find out what are the mistakes? Thanks!