I'm building a dashboard for hotel purpose and I have this data set 



I having a problem here to come up with a formula how to calculate available room on the given date since there are many different people check out on a different date.

I tried Googling it and I found a solution where COUNTIFS is being used in excel. Anybody know how can I solve this in qlik sense measure ?

Dear all,

Am I the only one to request this feasture in NPrinting 17 ?  I successfuly  used the feature with Nprinting 16 . In my case  it was  to manage  "merge cells".   I added some "merge cells" just above my headers to group with a nice banner my measures.

I'll to do this report in HTML but honestly with I'm going to spend more time on it

"The possibility to embed Excel reports in the e-mail body is not present in the NPrinting 17 and higher release and it is not in the road map so far. Only HTML reports and QlikView entity reports can be embedded."

are there other people in the same case as me?  

Hello everyone,

I have a problem that I'am not understanding the reason.

I've been working with QlikSense (2019 June's version) and I created the following bar chart and it is perfect:

On X-axis I customized the range [Min/Max] and the values are between 0 and a variable that is the sum of both expressions of the chart.

Yesterday I updated QlikSense to the last version (2019 July) and the same bar chart is now looking like this:

Why is that grey bar appearing?

I tried to limit the dimensions and it didn't work.

I tried to customize the X-axis only with Min = 0 and IT WORKED BUT I'am losing a behavior that I want.

I tried the same app in the previous QlikSense version and it looks perfect again.

Is this a bug in the new version?

@Gysbert_Wassenaar 

@sunny_talwar 

@swuehl 

Thanks in advance by your help and availability.

Best regards,

V.Castro

Hi all,

I have a pivot table as shown below:

In this, I'm trying to calculate 80% Potential savings for each Supplier and the number of dimension values(controlled by the panel on the left, 'Levels') that make up this 80% savings. I have written a formula for this as follows:

=Count(Distinct

Aggr(

If(

Rangesum(Above(

Sum(Price_Red)/Sum( total Price_Red)

,1,RowNo()

))<=0.8,$(vDim1)),

($(vDim1),(=Sum(Price_Red),Desc))

)

)

where 'Price_Red' is the savings value and $(vDim1) is the variable controlling the dimension values that are needed to be counted.

But the thing is, I want to display this count by each Supplier in the table and right now, this only happens if I select each supplier individually from the table.

I tried looking into Sunny's answer here and modified my formula but still doesnt give the required output. Please help me include the Supplier dimension in this calculation.

Attaching the qvf for your ref. Thanks in advance! @sunny_talwar @tresesco 

Good Day,

Please help the best approach in linking two tables (using left join) with multiple fields, please see below sample query

table1:

LOAD

cust_id,

app_id,

account_number

FROMsource....;

LEFT JOIN(table1)

LOAD

cust_id,

app_id,

reasons

RESIDENT (table2);

I need to link table1 and table2 using cust_id and app_id fields with OR operator

Thank you

Hi All,

I'm having a problem with calculating time.

In our planning-tooldatabase I have 2 time fields. (Planned time and the time spend)

Those are numeric for example if you get 16 hours in the database we zee 1600, if you get 2h and a half you se 230 in the database.

I can create a timefield in the script by using those 2 

Interval((left(num(PlannedTime,'0000'),2) * 60 + Mid(num(PlannedTime,'0000'),3,2))/24/60,'hh:mm') as PlannedTimehhmm,
Time((left(num(PlannedTime,'0000'),2) * 60 + Mid(num(PlannedTime,'0000'),3,2))/24/60,'hh:mm') as PlannedTimeTijdhhmmTime

And the same for the SpendTime.

But how can I subtract those fields so I get the time that is available for this order?

Regards,

Kris

Hello,

I would like to use existing search feature in my own extension.

How can I programmatically invoke such window when user clicks on a search icon in my extension? I can't find source code of native table so I can't check how it's done. The same search window appears when clicking on filter pane element, but again, I can't find the source code.

Both native table and Vizlib table use the same search feature so I believe it must be somehow accessible. This widget is very similar to the widget provided by Selection API (when you click and select) which is available for programmers, but I can't find a way to enable this standard search functionality in my extension.

Hi

I received below error message when reload License Monitor. Our default virtual proxy has window as authentication.

Where else I should check?

Best regards,

susan

Can anyone tell me what is wrong with the following expression:

=Count({<$(vNumber)={'Strongly agree'}>}$(vNumber)
/
Count({<$(vNumber)={'Strongly agree','Agree','Disagree','Strongly disagree'}>}$(vNumber)

i am trying to work out the percentage of strongly agree answers out of total responses. 

I am trying to create a variable so i can flick between the questions however the above formula is not calculating

Hi!

the last release of June 2019 includes the following improvement:

• Improved tooltip for stacked bars now displays positive and negative totals.

I have carried out the update from Qlik Sense April 2019 to Qlik Sense June 2019 because of the bug: "When trying to show or hide chart objects with the Show/Hide Container extension, depending on the defined variable value, changing to another sheet and back does not seem to refresh the view."

The thing is:

First: the bug continues existing…

Second: now the bar & area visualization display negatives values in the y-axis even when there’s no negative value in the measure.

¿How can I remove negative y-axis values when they are not necessary? I’ve tried to look for each option that the object allows to parametrize but I haven’t found the way. I just need to show from 0% to 100% (grid height relative to max bar is = 1 already)

Thank you in advance!