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

Hi, 

This is my code in a dimension in straight tab: 

=if([TOREP_COMPLETED_DATE] >= Monthstart(AddMonths(Today(), -1)) , 'P1M',
if([TOREP_COMPLETED_DATE] >= Monthstart(AddMonths(Today(),-3)) and TOREP_COMPLETED_DATE <= MonthEnd(TOREP_COMPLETED_DATE, -1), 'P3M',
if([TOREP_COMPLETED_DATE] >= Monthstart(AddMonths(Today(),-12)) and TOREP_COMPLETED_DATE <= MonthEnd(TOREP_COMPLETED_DATE, -1), 'P12M',
if([TOREP_COMPLETED_DATE] >= YearStart(AddYears(Today(), 0)) and [TOREP_COMPLETED_DATE] <= Monthstart(AddMonths(Today(), -1)), 'YTD'))))

My Question :

Each condition (if) is evaluated according to the result of the previous one. It's right.However, I wish to evaluate each condition from the beginning and without taking into account the previous result in order to have the right amount for each period.

Thanks for your help.

Fred

Show Less

Hi,

We have Qliksense Tabular Data in Qlik native straight table and Output format PDF with Excel as template.

Some rows have large text, that could even be more than a page.

Qliksense and NPrinting both are NOV 18 versions.

Issue:

Excel cell size has row height limitation of 409, so data gets truncated after this.

Workaround partially working:
Splitted data into multiple rows, issue described below:

The page has 2 table, upper table has around 25 columns and lower table has 7 columns, each column needing varying column width
So, had to align n columns of upper table to 1 column of lower table, so this needs merge cells in lower table, this merge happening only on 1st row

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, 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.

Tabular Data use as Image so that conditional formatting in the Qlik table is retained.

Qliksense and NPrinting both are NOV 18 versions.

 

Issue:

'Use as Image' needs initial size set, if data grows it gets truncated, if data reduces, it leaves blank space after data ended.

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 tabular data row heights and column widths adjusted as per their content size, similar to auto fit feature in excel

Qliksense and NPrinting both are NOV 18 versions.

 

Issue:

All columns are getting set with same width

All rows are getting set with same height

In PPT, No 'AutoFit Column Width' option like in Excel

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 multiple straight tables data in single slide

Qliksense and NPrinting both are NOV 18 versions.

 

Issue:

2nd table overlaps onto 1st table
2nd Table starts after 1st row of 1st table

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.

Tabular data has "Conditional formatting" like text color, background color.

Qliksense and NPrinting both are NOV 18 versions.

 

Issue:

Even though "Keep source formatting" checkbox is selected, when data used as table, all "Conditional formatting" set in Qlik table gets lost in nprinting output.

Only static formatting like (text color expression "red") applied to output report.

Please help how to apply conditional formatting in PPT template in NPrinting.

 

Thanks,

Narayana

Show Less