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!!

Olá.

Por favor, há alguma solução de somase para o caso?

Tenho uma tabela com campo "NF", "NF vinculada", "Operação" e "Frete".

Operação há dois valores "Receita" ou "Remessa".

O valor do frete está ligado às notas de "remessa", mas preciso trazer a soma dos fretes junto às respectivas notas de "Receita".

Há menção da respectiva nota de "receita" para cada nota de "remessa".

Obrigado.

I have created a bar chart with data that drills down. I am having problems with calculations in that chart. There are two filters, the bigger one is sports and the smaller one is athletes. Given the 5 biggest athletes in a few major sports, I want the chart to show a % of pay each of those athletes gets out of the sum of all 5 athletes.

My current code looks something like this:

Sum(Athletes_money)/sum(total Athletes_money)

This works when a specific sport is chosen, but when no filter is chosen and the bar chart shows all sports separate, the individual athletes money is divided by all of the athletes that are in the filter. Is it possible to make the denominator the total of just the athletes sports grouping instead of all athletes?

I have a table with 100 columns

I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'

But my code is throwing the error fieldname not found in the for loop...

what i did

// first filter column 1 for ID001

[TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';

// Loop to check for date value =  '2025-01-01' if have flag as 1

For f = 1 to NoOfFields('TEST')
LET F1 = FieldName($(f), 'TEST');
[Fields]:
Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
AutoGenerate 1;
Next f
DROP Table[TEST];

Any idea how to solve? Thanks in advance!

Hello,

I have a line chart in which I want to display a specific number for each week of this year. For this I have the dimension "Created-Date_Week". In my data, I currently have weeks of this year up to week 17, but I want the x-axis up to week 30.

Is it possible to extend the x-axis to week 30, even if I only have data up to week 17?

Thanks and best regards!

I need to use the color for stacked chart based on the legend dimension value.

For example, if I show the sum value for month and Status in the stacked bar chart , the color of the bar should be based on the status value.

I used the below expression in the Appearance >> Color and Legend >> Use custom colors

=pick(Match(ErrorStatus,'Success','Service Unavailable','Bad Gateway'),'#009845','#004080','#F20000')

but its not working properly. If I made the selections in the status then the bar is appearing with the corresponding color but if there is no selection then the bar itself is not showing.

But if I scroll over the chart area the tooltip is appearing as normal.

Hi Team,

Ourt business is planning to upgrade the QlikView application.

From 12.7 to 12.8,

let us know if the 12.9 is releasing.in this May, and we should wait for this version. 

Hi ,

I have two dimesion  and we have used secondary dimensionality in measure to create a pivot table as shown

now based on selecting any dimension user wants the measure to be sorted in descending order please se the measure below.

 we have used dimensionality concept in our expression as shown below

Please let me know how to sort all measures if we select any one  dimension

thanks,

Suresh