hi, 

i need help. we want to put a qlik app on  tv screen with a Optisings solution. we have every time a mistake like this. what we can do that we don t have this? mistake 500. what is it?

I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is an inline table

This is the excel template-

Then the inline table -

Then the table uses _metric as a dimension.  Here is the QV report

I am trying to format the row labels with indentation.  I can make them bold by including

<b> in the _Format column.

I want to indent particular rows like such –

I have tried to use the format column and &nbsp to insert spaces, but that did not work

Is this possible to do ?

Any thoughts on this would be greatly appreciated.

Thanks,

Brian

I have two Q VD files (table1, table2) with the same column names, and I would like to append them into a single table called "final_table". The append operation should only occur when the primary keys do not match from both tables. However, with the current code, I am only seeing IDs from table1 appear, and IDs from table2 are not being included.

I would appreciate your guidance in resolving this issue.

LOAD *
From table1;
Concatenate LOAD * FROM table2
WHERE NOT Exists(id);

Hello

I'm reading a qvd file which contains data for a table that has a column whose data is in xml format

I'm reading the xml field and then parse it to get the fields in the xml tags along with their values

during reload I get an error saying

An invalid character was found in text content.

On line number: 1. On column number: 659.

but I don't have that number of columns?

Check attached QVW and QVD file

the script works fine if I put the condition where RecNo < 367

but if I remove this condition the script works fine - and I have to in order to read all data

can someone help me identify what might be wrong?

Hi Everyone, so I have geo map which shouldn't affect when I select year month, So I have provided the expression to ignore this dimension but in size&shape properties, there are two layers point layers and area layers, except size&shape all the properties are dimension, so How should I stop the dimension from reflecting from year-month?
right now after selecting it is removing countrys(area layer) and some station(point layer) when I select year-month.
Used expression: SUM({<[YEAR_MONTH]=>}[GEO_AVG_PRICE] * [GEO_QTY])

Before selecting year month filter:

after selecting (it shouldn't change anything, It should show the map as it was before as in above image):

Hello everyone, 

please refer to snapshot , the input table has dates and classification column along with other columns. I want to create this shown output where latest classification is selected for each key as per week

note: week starts on Mon and ends on Sun. And I have highlighted dates falling in same week.

I want to do it at script level only.

Hi There,

I have the following SQL query, which retrieves data for the last 5 years based on the snapshot taken at the start of the financial year. I would like to make it dynamic so that I don't have to modify the code next year.

I would greatly appreciate your guidance on how to achieve this.

Hi all,

I need to include a test in a set analysis. The expression that is not in bold works fine. I just need to include a condition now, i.e I need to sum the sales when  weeks_left_to_event was a smaller number than current_weeks_left_to_event

=Rangesum(Above(Sum({<year_event=, weeks_left_to_event<={"current_weeks_left_to_event"} ,month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} quantity), 0, RowNo()))

Any help much appreciated!!

Hi,

 I am creating a pivot table where I have a measure which gives a count of ID. I need to to make it a dimension and collapse it so that it shows the count and upon clicking the expand option, I have to see new set of dimensions which will give the data for the count.

Something like this