Welcome to Qlik Community

Hello guys!

First of all, I would like to thanks everybody here who is helping me a lot. I'm learning too much here, and I believe I'm working with QlikView 12 horas a day, for more than a month. This software is amazing!

Now my question is:
How can I calculate (via expression), the linear trendline, starting from a specific date ('18/03/2020')?

Look at that:

In this case, QlikView is calculating the overall Trendline (based on my dates selection), but I would like to get something like this - see below:

I'm currently working with the following expression, but I'm not getting the correct result:

if( DVPG > '18/03/2020',
	linest_m(total aggr(if(sum(VDAF) ,sum(VDAF)), DVPG), DVPG)
	* only(DVPG) + linest_b(total aggr(if(sum(VDAF) ,sum(VDAF)), DVPG), DVPG)
)

This is the chart I'm getting, and obviouly it's correct:

The Date field is called DVPG, and the Y axis field is called VDAF.

How can I do that?
Thanks

Hello guys,

How can I create a Script that divides the current value by the next row's value, as you can see below:

...

I have lots of INDXs, so, for each INDX, I want to calculate the DIF.

As you can see, I want to create the column DIF that is row #1 / row #2. 
Example: 13.43/13.53 = 0.992609

This is the script where you can find my code:

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

How can I do that?
I want to do it by Script

Thank you so much!

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. 

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 

Hi,

What currently i have

1) Qlik Sense app with data loaded

2) Straight table created with complex set of formulas - 4 to 5 fields are calculated. General structure table is as follow

ID, Date, Measure 1, Measure 2, New Measure 3 (Measure 1 / Measure 4), Category of Measure 3 (Q1, Q2, Q3, Q4 and Q5 based on value), Measure 4, Measure 5, New Measure 6 (Measure 4/ Measure5) 

My requirement is to have a  separate analysis on this straight table by  another set of complex set of formulas on the all calculated measures.

All my calculations are dynamic based on many filters.

Not sure if this is possible.

Hi tresesco    Vegar

sunny_talwar

i have  table   with below columns

Table1:

Region, Month,product ,Amount

Table2:

Geography,FiscalMonth,Item,Sales

SO now i have loaded Table 1.   created some report     stright table with 3 dim and one measure

now  same report i want to show  with second table  in same application  data remain same  coulmn names to be changed dynamically.

how to achieve this?

Hello!

I have following example  table. Its just an cutout of a very big database:

I already got so much help from many here, about how to set the format right. For example Date(Date#()) function and so forth. Its simply not working out for me. I get other problems when I set it manually to a date 'MM.YYYY' format or problems with loading the column at the script with a date related function. 

So I  try it to take the column now as a number: I guess for Qlik its just a general number Column. Since its not a "date column" I cannot use Date function relate to the time of today for example in my set expressions and if-functions.

I want to express the following in an KPI window: Always show me the Sales Value (no sum, just whats in the field respective to the month) of todays month. 

So as an example: In January please return 100, If today would be a day in February please return 200, and when we are in March 400 and so forth....always the actual month we no are at. 

My problem is following: how Qliksense actually interpret an format like 01.2020? when we get to 2021, will Qlik get the difference between 01.2020 and 01.2021? If  for instance it doesn't interpret 04.2021 (since its next year and also later in the timeline) bigger than 12.2020 I have a big problem using Min/Max Functions.

Can someone write me a set analysist  expression, a IF-Function or anything else which solve my problem?

Thanks a lot in advance!

Hi guys,

Please Help Me to get  Free Horizontal list box or filter pane extension which is working,

Need a Filter pane which shows the values in horizontal without a dropdown option 

Hello,

I found the following information on the qlik help site: 

The powerful thing of a Set Analysis is the endless possibility of combination dimensions and even function with Dollar Expansion. 

For instance if I want to show a KPI windows with the CURRENT monthly sales there are plenty of option to do so with Today() function.

How to use these in If-Statements. Dollar expansion needed? 

I know we can put if-statements in Set expression, but how to manage other way round?

Can you please provide examples?

Thanks in advance!

Best

Hi everyone! 

I'm trying to learn to build my own visualization extensions. 

The problem I'm having is that the extension I created works well if I run the dashboard from the localhost server, but it turns into a blank sheet if I try to open it with the Qlik Sense Desktop App. 

Could you please give me a hint concerning what might cause the problem? 

The zipped Extensions folder is attached