I created a hotel dashboard myself and I made a filtering on some dates and some times not all corporate guest made a booking on that date. 

How do I replace this blank chart with a message that is saying 'No corporate booking in this period' 

Thanks

Show Less

Hello community!!

I am currently working on a dashboard that allows me to identify invoices that are equal to zero.
I have noticed the existence of some charges in the invoices that not in all cases is correct to be billed as "shipping cost invoice" and "delinquency cost". Then I should be able to calculate two KPI'S:

1) when the invoices are equal to zero.
2) and when the sum of "Total Invoive Charge" in field
  INVOICE_NUM is equal to zero, assuming there are no charges: "shipping cost invoice" and "delinquency cost"

Point 2) will help me establish more precisely the service charges that really are zero. 

 The previous example shows a case that when adding the threes charges of the invoice the total is 8, but really the charge is zero, since it includes the items not to be considered for the analysis.

The third requirement is not a KPI, but I would like to be able to write a field from the script in order to have the "Total Amount of the Invoice". Currently the data brings the total but at the level of charge.

Finally, I have included a ready list related to point 1) and allow filtering the cases with invoices equal to zero, with the following expression: = Aggr (if (sum ([Total Invoice Charge]) = 0, 'Invoice Equal to zero ',' N / A '), [Invoice-Num]). I would like those cases only to be in a pivot chart (try it but it shows me the rest of the cases) and also in a bar chart.

Thanks again, counting on your usual help

 

 

 

 

Show Less

Hi, We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting. Need to Display table only when it has data Qliksense and NPrinting both are NOV 18 versions. Issue: Shows table header, even if it does not have data. We can add condition in setup to not generate report if particular table does not have data, but we do not see option only not to display that particular table in report generated. Please help how to solve this Thanks, Narayana Show Less

Hi,

We have Qliksense Tabular Data in Qlik native straight table and need PPT Output format using NPrinting.

Need to use some variable data as headers in PPT output report.

Qliksense and NPrinting both are NOV 18 versions.

Issue:

Variable name also appears along with variable data when variable used in ppt template

Please help how to solve this.

Thanks,

Narayana

Show Less

Hi 

I'm load a Line Layer of 70,000 lines into GeoAnalytics Line Layer. Each line has its color defined by a measure (0.3-0.6).

I found the loading and response time of GeoAnalytics is about 5 times slower than the old map. Is this normal?

Thanks

Bing

Show Less

Hi everyone, 

I hope the title is not too confusing, but basically I have a table looking like following: 

Table:
[date, sales volume, customer
01.01.1970, 100, A
01.01.1970, 200, B
...
31.12.1970, 500, C
31.12.1970, 550, D
...
01.01.1971, 120, A
01.01.1971, 230, B
...
31.12.1971, 550, C
31.12.1971, 650, D
]

What I need to do is to have table which basically shows 10 clients with biggest sum([sales volume]) this year,

and shows those clients' ranks in the previous year.

 

I do understand how I rank current year (with set analysis), but can't get my head around how to rank the previous year's sales in the same table

Any help would be really appreciated,

Thanks in advance 

Show Less

Hi All,

I have attached a Test.qvw and Test.xlsx to make this request a bit easier hopefully. 

I need to, using a pivoted spreadsheet find the intersecting values between 2 calculated expressions (for convenience i have simplified these in the example) - Turnover and Margin%. If the Turnover is between the threshold provided and the intersecting Margin% falls in one of the Margin Tiers the intersecting value must be provided as the result. 

I am not considering Intervalmatch because the Turnover and Margin% are actually complex calculations calculated in the frontend and there is no link to this spreadsheet using store or any other field. It is a global guideline.

 

 

 

 

 

 

 

Thank you in advance!

Regards,

Richard

Show Less

Hello Friends,

Appreciate your time.  I am using a Pivot table for one of my chart , but is it possible to export the same in a merged format as like a straight table  data while exporting alone anything using native QlikSense or Vizlib is ok.

 

Thank you,

Kiruthiga

Show Less