Welcome to Qlik Community

Hi, 

I have a field (SMSNo) field where cell numbers are captured in, but i have occasions where people capture  special characters in, i want to created an if statement in my script to identify just the client records  whom has a special character in the (SMSNo) field and where the number does not contain 10 digits. I also want to eliminate the fields that are blank.

Thank you

Hello guys,

How can I divide the current value by the next value on a row via Script?
Check the following example:

As you can see above, I have some INDXs, and I want to calculate the DIF:
DIF = Current value of VDIF / Next value of VDIF 
Example: 13.43 / 13.53 = 0,992609

Note that I have some INDXs, so this calculus should consider the INDXs... it's not just dates.

This is my script:

For each Index in 'BRL=X', 'EURBRL=X', 'CL=F', 'GC=F', 'SI=F', 'BTC-USD', '^BVSP'
	Add
	Indices:
	Load
		Date(Date#(@1,'YYYY-MM-DD'), 'DD/MM/YYYY')	 				as DVPG,	// Data a ser considerada						 
		'$(Index)' 													as INDX,	// Índice
	    Num#(@2, '#,##0,00;-#,##0.00', '.', ',')					as VDIA, 	// Valor do índice na abertura
	    Num#(@3, '#,##0,00;-#,##0.00', '.', ',')					as VMAI, 	// Valor mais alto do índiceno dia
	    Num#(@4, '#,##0,00;-#,##0.00', '.', ',')					as VMBI, 	// Valor mais baixo do índice no dia
	    Num#(@5, '#,##0,00;-#,##0.00', '.', ',')					as VDIF, 	// Valor do índice no fechamento
	    Num#(@6, '#,##0,00;-#,##0.00', '.', ',')					as VIFA, 	// Valor do índice no fechamento ajustado
	    Num#(@7, '#,##0,00;-#,##0.00', '.', ',')					as VDIN		// Volume negociado do índice
	FROM
		[https://query1.finance.yahoo.com/v7/finance/download/$(Index)?period1=1431043200&period2=1593907200&interval=1d&events=history] 	//5 Years Period
		(txt, codepage is 1252, no labels, delimiter is ',', msq, filters(
		Remove(Row, Pos(Top, 1)),
		Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'null')))
	));

Next Index

And I would like to do it via script
How can I do that?

Thanks

I am joining two tables.Lets say for example(Table A, Table B)

Table A:

A,B

Table B:

A,C

The result from the above is not matching when I put outer join between these two

Table A:

A,B

outer join(Table A)

Table B:

A,C

Ideally both should be same right?

Hi All,

How can I go to specific line of the code in Qlik Script. Suppose If we have QVD generator which will create multiple qvd's with in QVW file in different tabs. So if we want to go to specific tab and execute the script from the there.I don't want to execute all the sheets.As I can not comment each tab and execute the script. 

hello

probably the title does not say much, but here is my problem, sorry if it has been posted already by someone else

I have the following data structure: Client id, Client Region, Salesperson, Sales 

I need to display Sales calculated at the Region level in a table which only shows a subset of the clients - and this subset is defined by a selection on the Salesperson field

I could not manage to produce a formula that works in a predictable manner.

I also tried creating a separate table storing only region and region sales, but for some reason that also does not work correctly... maybe because the connection is via the Region field and not the client field, I don't know.

a solution is to use an apply map, but it is impractical for me (the data structure is much more complicated and I would have to use a compound key etc) so I was wondering whether a formula exists

thank you
LM

example mock data

Hi Team,

I want to create a flag in QlikView Script, If I select entry_date. Total no. of record in entry_date is 644 and I have selected 401 value. So I need a flag like Y for all those value selected and N means not selected records.

Hope you got my answer. Can any one help me on this.

For data related qvw, I am attaching my qvw.

Regards,
Sona_SA

Hi All , 

Please find the attachment of the excel sheet , 

I want to show subtotal and Total  in a table in QlikView . 

I have Department and Category and Sales , 

As shown in the screenshot below is it possible to achive this in Qlikview ? 

Thanks in Advcance 

I am having trouble in using Filtered Views in the QlikView Dashboard. When i use the Filtered views and run locally dashboard works fine. But, problem occurs when i publish to the QMC & it won't retrieve any results from the view . This problem doesn't occur when i use tables instead of Filtered Views

For eg.,  Using following table works fine

LOAD id,

name

SQL SELECT *

FROM Contact (NOLOCK);

 But if i use the following Filtered View, the view doesn't execute & won't retrieve any results after publishing to QMC.

LOAD id,

name

SQL SELECT  *

FROM FilteredContact (NOLOCK);

Does anyone has a fix to this or any suggestions on how to handle this ?

Hi,

I have day field which is no. of days from starting onwards in my data like 1,2,3,...

Here to get the no. of weeks divided the day with 7  and by using ceil i got but it displays week even for incomplete weeks  how to avoid those 

ex.

field have 1 to 16

how to avoid 15 and 16 day values

Hi Experts,

Can any one please help me to build the below cumulative bar chart(like in second chart)

Original chart has the data like below in first chart.

Requirement: 

I have to build a cumulative bar chart with May to Jan sorting and need to show the highest value on May like second chart.

Please help me on this. I have tried the default accumulation but getting May with low value.

Please find the below attached application and source file.

Thanks in advance.