Hi  everyone,

I have the "Date" and "Price" fields in a table.

I would like to have a line chart in which the fields "Date" are displayed as a dimension and "Price" as a KPI.

The raw data looks like this:

If there are several prices for a date, Qlik does not display a price for the day and does not display the date in the diagram.

Is it possible that ALL values are shown to me in a line chart? Or is that not possible with a line chart? If not, do you have a suggestion for a nicer and better representation?

I hope you can help me 🙂

Hi Community!

We're facing an undesirable behavior in an agregation funcion working with filters.

I'll try to explain myself with screenshots and expresions.

We have a table with YearMonth dimension  and an aggr expresion:

Sum({<$(vSetRolling12Modifier)>}Aggr(Rangesum(Above(count({<$(vSetRolling12Modifier)>}[ID Llamada Entrante]),0,12)), ([Año-Mes], (Numeric, Ascending)) ))

with this expression we want to show, for every yearmonth, the number of "ID Llamada Entrante" in that month and previous 11  (for 2021-june, the amount of 2020-july -> 2021-june; for 2021-may, the amount of 2020-june -> 2021-may)

Where $(vSetRolling12Modifier) =

[Date]=,[Day]=,[Weekday]=,[Year]=,[Month]=,[Quarter]=,[YearMonth]=,
[_MonthSerial] = {">=$(=Max({1<$(_f_DateIsFuture)={0},_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_MonthSerial]) - 11)<=$(=Max({1<$(_f_DateIsFuture)={0},_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_MonthSerial]))"}

We use vSetRolling12Modifier to avoid calendar filters and to take into account the previous 12 months

It works fine when we don't apply filter (data has been validated):

But when we apply a YearMonth filter, previous months data changes, wich is no correct.

Can someone help us to reach the correct expression?

Thanks in advance.

Regards,

Alonso Torres.

Good morning,

I have a very frustrating issue at the moment. I have been working on a Qlik dashboard, however when I was using the properties option for one of my charts I think I clicked off the Properties window and now it's returned me to the main app, but everything is greyed out and I can't click on anything on the application, dashboard or toolbar options. I also can't get back into the properties dialog box to close that down.

Any help would be great as I fear I may need to close the app losing my work.

Thanks 

James

Good morning,

I'm trying to link a cost to a specific person. I've got a type of cost and a final date until when that cost is linked.

For example the date 10/02/2020 is < of 31/07/2020 then the 70 will be linked to pippo and so on....

How can i do it? If there isn't a date it means that it still works now.

TAB1:

LOAD * inline [
COST, NAME, FINAL_DATE,
GD56YTG, pippo, 31/07/2020,
GD56YTG, teo,,
FF56YTG, gino,];

TAB2:

COST,  DATA,  VALUE,
GD56YTG,10/02/2020,70,
GD56YTG,11/06/2021,30,
GD56YTG,20/05/2021,40,
FF56YTG,20/05/2021,40

Hello,

I have a free tier account of hosted Qlik Sense and I'm trying to ingest my CosmosDB data.

The several documents I found e.g. https://support.qlik.com/articles/000077160 cannot help me. The option ODBC in the source type is not displayed for me. Other documents suggest to install a connector but since the service is hosted, I don't have this capacity. Can you help me on this?

Thank you

Guillaume

Dear Qlik Community, I am stuck in creating a YTD and need your help.

Please look at the table below, i have the Col 2 - Nb of Projects and Col 3 - MTD values. I need to calculate the YTD value

YTD = weighted average of MTD & Nb. of Projects

For ex - YTD for Jan-2021 = (80*5)/5 = 80%

YTD  for Feb - 2021 = (80*5 + 50*6)/(5+6) = 63.63% and so on

Can some1 help me to create the last column in set analysis using the YTD formula described above? in case of any questions feel free to reach out to me

Best,
Akash

The scroll bar moves to the left when cyclic dimension is changed.

▼object
・pivot table
・set cyclic group dimension
・enable [Preserve Scroll Position]

▼procedure
1. Open the attached sample.qvw file in QlikView Desktop.
2. Move the scroll bar to the right end.
3. Change cyclic dimension.
4. Move the scroll bar to the right end.
5. Change cyclic dimension.
6. You can see the scroll bar was moved to the left.

I want to specify the position of the scroll bar.

Hi,

I wanted to know how the Qlik Sesne App and Mashup work on server.

I need to know the process/work flow like I have a app with mashups.

https://servername/extensions/appmashup.html

this mashup has dropdowns, KPIs, charts, all are calculated using lists and hypercubes.

what happens if I open this page? what request sent to QS server? 

what Qlik Engine do in this case? 

will Qlik Engine first loads the app on to memory (RAM) then creates calcuations using Hypercube?

hypercubes use calculation memory or is it separate memory? 

Hi,

I have a question: is there a way to utilize QVS API to add users to distribution list in QlikView?

And is there a proper documentation for QVS API for the people who want to call API methods directly from Linux command line (not using C# or PowerShell)? This, as far as I know, is possible using cUrl (at least based on the article below), but I couldn't find an appropriate documentation with all the methods available. 

https://community.qlik.com/t5/Knowledge-Base/QlikView-Call-QMS-API-with-cURL/ta-p/1717004?_ga=2.149617782.1737571661.1626944753-1696473308.1560249751

I know a similar question has been asked before (https://community.qlik.com/t5/QlikView-Administration/QMS-API-add-remove-AD-user-to-Publisher-task/td-p/787012 ). However, there is no accepted answer in this thread.

Best regards,
Vlad