Hi,

This is a problem I can see other people have had on the forums (here and here), but neither deal with timestamps on the x-axis.

I have this visualisation of frequencies per hour of the day. I want the x-axis sorted from 00:00 to 23:00. As you can see, it is not sorted, even though I have selected 'sort numerically'.

How can I sort these items in my visualisation?

How to load Excel File with multiple sheets and each sheet name is different.

Example:

File Name: DataFile.xls

Sheet 1 Name: loream

Sheet 2 Name: excelbu

Sheet 3 Name: Document!°

.

.

.

Sheet n Name: n

Hi all,

I need to create last week this year vs last week last year date. I tried creating last weeks date which looks fine but unable to create last week last year date.

Date ranges from 2017 to 2019 .

DATE = '>=$(=WeekStart( Today()-6)) <=$(=Date(WeekEnd( Today())-7))'

Could anyone please help me?

Thanks in advance

Hi All,

For client authentication for Qlik sense mobile, i found only two ways , one for web hub  another for receive client authentication link from adminstrator, but both of them we need end users take actions, do you know any ways we dont use end users take actions? When the employee login with account, they can see the enterprise server. Thanks.

Best Regards,

Haifeng

Dear Members, 

I am trying to build one logic from excel to Qlik Sense Cloud. But after several efforts it's not working as expected. So need your help. I have attached test data. This has three data sheets for Aug'19. 

1. Orders - these are orders created in one month.  

2. Activities - these are activity closed in same month. 

3. Orders_2mths - these are last two months orders data. It's a reference sheet for activities table. Activities pick IN_OUT & Country field from this sheet. 

Now I am trying to build some charts based on above data. one of example is given in chart sheet. This is using Orders & Activities sheets only. 

There will be two charts one for country & other for months. Country chart will show only latest month data and Months chart will show monthly trend and added month bars as year passes. 

Now challenge is , if we connect Orders & Activities on basis of Order_No & Month. We lost few orders due to this mapping. If we add them only using Order_No, we didn't get monthly chart.

Country is available in both Orders & Activities. But we need to use order's Country_O for chart preparation as it's in denominator of ratio. 

Please share your thoughts to build this logic. 

Test Data

Hi All,

I am new to mashup and my understanding is that we can combine objects from multiple objects into one web page. 

I was trying to create the mashup web page and trying to add kpi's, line chart, bar chart and filters from two different apps and my selections are filtering only one app. Should we create any type of association for the filter to work. Can someone please help me in with this?

Thanks,

Varun

Hello Qlikers!

I'm having issues with a bar chart that mixes both set analysis, and a color expression.

I've set the set Analysis as follows:

Sum({$<Month=>}[Base_Sales.Amount])

and the color expression as:

if([Base_Sales.Key Figure]='Bud Sales BR',RGB(130,200,220),IF([Base_Sales.Key Figure]='Act Sales AR',rgb(255,180,000),rgb(170,180,000)))

Separated, both the set analysis and the color expression works fine.

If I filter by month the table doesn't change the amounts (as it should), but the colors do change. The values that aren't included in the filter all turn to RGB(170,180,000)

Could anyone help me?

Thanks

Since upgrading to Nov 2018 we have been experiencing an issue of qvd files being locked. It's happening around 4-5 times a week in our production environments and we have to manually go into the MMC to unlock the file.

Is anyone else experiencing this issue? We have a support case raised but wanted to reach out to the wider community.

Happy to provide further detail

Hello, 

     I have a couple of reference lines on my bar chart. I want to keep the text labels but remove the quantitative values associated with them. Please help. I have attached a screenshot for reference (only the values circled in red needs to be removed).

I have an extension that uses a list generated by the user to populate a list in application. I have added it to my properties but I can't seem to get the label to work. Below is my code and a screen shot of what I see. 

var settingsDefinition = {
			uses: "settings",
					items: {
						MyList: {
							type: "array",
                            ref: "listItems",
                            label: "List Items",
                            itemTitleRef: "MyDropDown.label",
                            allowAdd: true,
                            allowRemove: true,
                            addTranslation: "Add Item",
                            items: {						
								MyDropDown: {
									label: "Field",
									type: "string",
									component: "dropdown",
									ref: "fieldList",
									options: function() {
										return getFieldList().then(function (items) {
											return items;								
												});
									}
								}
                            }
						}
					}
				}

So we made a title for the sheet like so (see pic):

and it appears on the sheet itself fine, but when i pull said sheet into html via the iframe like so:

<body>

<iframe src='ourspecialuri/single?appid=314afaf5-2c3c-4fad-a51f-c6de4799f3b5&sheet=e3ad6687-6050-4899-b3f8-8adde50fbc92&opt=currsel&select=clearall' style='border:none;width:1200px;height:1000px;'></iframe>

</body>

...the sheet appears, but the title bar (as seen in pic) does not show at all. the space is there for it, but it just reflects the background of the qlik sheet

Experts,

I have two tables which are connected by a primary key called SKU.  Table 1 has daily sales data for each SKU and Table 2 has daily advertising spend for each SKU.  Both tables also have separate date fields and their basic structures are outlined at the bottom...

My goal is to use set analysis to get the sum of unit sales IF the OrderDate = AdvDate so that if i create a filter using the AdvDate field, my sales data will filter to those dates as well.

Here is all I have so far but it is not working:

SUM({<[ord_dt.autoCalendar.Date]=[adv_dt.autoCalendar.Date]>}qt_ordd)

TABLE1:

TABLE2:

Thanks!

In the video "Creating a Gantt Chart in Clik Sense", it is said that it is possible to generate such a chart in Qlik. When I apply the recipe, I dont have the expected result. All my bar begin on the Y axis instead of on the date the task has begin. I dont know what I am maissing. Did not find any answer in the community. We do not want to use any extension for this exercise but do the whole chart directly with the included Clik Sense tools. It is my first support request. What do I need to provide to you in order to find a solution? Thanks in advance

Olá pessoal!

Preciso criar um cálculo em que eu consiga identificar quantos dias o colaborador estava afastado dentro de um período específico.

Tenho as duas variáveis abaixo que me dão os dias de início e fim do período que quero contar:

Set vPrecoSemanaINICIO1 = ' 07/08/2019 '; 
Set vPrecoSemanaTERMINO1 = ' 13/08/2019 ';

Após isso, em meu script tenho a data de início e término do afastamento do colaborador:

[AFASTAMENTO]:
LOAD
"Nome do Colaborador",
DATA_INCIO_AFASTAMENTO_MES_ATUAL,
DATA_TERMINO_AFASTAMENTO_MES_ATUAL
FROM [lib://LOJA PERFEITA/AFASTAMENTO_QVD.QVD]
(qvd);

Como consigo uma contagem de dias que coincidem entre os dois períodos?

Obrigado!!