Hi guys,

I have a table like below. I want to have two list box with status. start status and end status. when user select start status and end status we can show sum (duration) between these tow status for each message code. 

for example if we select  first status =2 and end status=5 we have two number. for messagecode=1 we have 100 and for messagecode=2 we have 70. what should I do?

Hi, 

I have 2 KPI's whereby each month, I have to update hard coded values. What would be great is to automate these, any idea how I can amend my code please to show previous months data? 

Sum({<Week = {"=MonthName(Week) = MonthName('01/12/2019')"}>}[Total Cost])

Hi,

I am building a Qlik Sense Extension that has two dimensions and two measures. What I need is that the measure one values should be calculated on unique combination of values of both the dimensions (which is the default behavior), but measure two values should be calculated on unique values of only dimension one.

So for example, if my data is:

And I chose dimension 1 as "A", dimension 2 as "B" and both measures as sum of "C", then in my extension,  "layout.qHyperCube.qDataPages[0].qMatrix" should return the following table.

It has one row per unique combination of values of dimension1 and dimension2. The measure1 is calculated on each unique combination of values of dimension1 and dimension2 (which is the default behavior). The measure2 is what I need help with. It should be calculated on each unique values of just dimension1 (and dimension2 should be ignored).

Is this possible. If so, how?

I am looking to remove results from a dimension where there has been no results for a set period of time.

As you can see from the image, James has had no scores for more than 6 weeks so should not show in the table anymore as he will have left the company. 

Thanks for any help.

Hi,

i'm using Qlik Sense and i am new to this. 

i need help on how to display current and previous 6 months data on the bar chart. I have 3 years data in total. 

Kindly help me on how to display the data in details. Please show me step by step. 

X-axis is Submission Date (YearMonth)

Y-axis Count(change request)

Hello ,

I am very new to Qlikview Scriptinng. I am having an issue with my script.

Data:

SQL select

Account.Account key,
Account.Account NBR,
Account.vsc key,
Accoun.Date key

Department. Department NBR,
Department.Department Date key,

Sale.sale DT Key,
Sale.sale ID,
sum(sale) as Total

vendor Account .Account key,
Vendor Account. name,
Vendor Account. CD
vendor Account.vsc key

FROM

Account,
Department,
sale,
Vendor

where Account.Datekey = Department.date key

And Sale.sale DT key = Department.deaptment date key

And account. account key = vendor account. account key,

and Account. vsc key = vendor account.vsc key

and // Date condition

group by

all the fields my the above tables.

I believe the table Account and vendor has inner join by linking the field account key(Bold lines). so, wen there is no data in vendor the account data also getting excluded.

I want the Account data even when there is no vendor data. so I need to perform left join.

Could anyone help me on this.

I feel like I'm asking a really stupid question (probably am), but I'm trying to find what the flags showing in the Qlik Sense Document Analyzer mean. Does anyone have a list of what those flags mean? Or how to fix? The app is written by Rob Wunderlich and the Flag I'm looking at now is called 'Suboptimal Numeric Storage'. It seems like this means we're storing dual data in about 200 fields. So then my question is, what is the impact? Is it really slowing down performance in the application? Or is there something else it impacts? I've read through the text files but all I find there is things that were added to the application, not a 'how-to-use' this app. Qlik Sense...not Qlikview answers please. Thank you so much in advance for reading - my question to the community has gotten no response.

Hi guys,

is it just me or is the Qlik Sense Business (formerly cloud) not necessarily very stable? I am mostly referring to windows timing out real quick and/or automatically refreshing/reconnecting when I am working in load script.

Anyone?

B.

2 tables with same keyname ARTNR

LOAD ARTNR,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

This generates a $Syn1 table

creating a grafic object will say all expressions deactivated

i need a connection by pickinng ARTNR form STAMMARTIKEL; and show all records in umsatzPOS with that ARTNR