Welcome to Qlik Community

Hello,

I'm trying to develop a chart but I am not able to build a measure in the way I desire.

Consider these two tables:

they are connected through ID_USER. 

I want to count the distinct id_shipment_detail where DATE=DATE_TICKET.

With this measure

count(distinct if ( DATE=DATE_TICKET ,ID_SHIPMENT_DETAIL))

it seems to me that the count considers the condition DATE=DATE_TICKET but excludes from the count the row with 'user4' (i believe it is because user4 is not in tableB).

How can I count the total of distinct ID_SHIPMENT_DETAIL, considering the comparison between dates and also including the rows of table A that have no connection with table B?

At the end, if I print a table with DATE, DATE_TICKET and the count measure, I want to obtain the following:

Thank you

Hi - I am trying to create a variable that does the following:

• Data contains Sales Date for the past four years (2016 - 2019) and the quantity sold
• I would like have a variable which calculates the sum of the quantity sold for the most recent year (hence 2019)

Table fields:

SalesDate

QuantitySold

Variable:

vYearMaxQuantitySold:

=Sum({$<[SalesDate.autoCalendar.Year] = {$(=max([SalesDate.autoCalendar.Year]))}>}[QuantitySold])

I try the formula above - does not work - any thoughts ? Jerry

Hi

I have a scenario, where i have to forecast the data based on the last Year Month Data. Below is the sample data

Qn : With the given data below - i need to forecast the data for Sep-20 till Dec - 2020 (Based on the Months Previous Year Data)

Ex:  For Sept 2020 - I should get the value of Sept 2019, as i dont have the value for Sept 2018

For Oct  2020 - I should get the value of Oct 2019, as i dont have the value for OCt 2018

For Nov 2020 - I should get the Average value of Nov2019 and Nov 2018 and goes on

@sunny_talwar 

Regards,

SK

Olá pessoal.

Tenho 2 colunas uma com  Total e outra com a Data de 2019 até 2020

queria colocar isso em barras e mostrar jan/2019 jan/2020 e etc lado a lado comparando os meses do ano passado com desse ano usando a medida de Total

tentei algumas formulas que achei aqui, mas não deu certo.

o que devo colocar na minha medida e na minha dimensão do grafico?

Obrigada desde ja

On sheet  6  Charts ,

based  chosen options is shows related data in all charts, 

 however when  clikcing one  certain  Chart i want to automaticly  clear one  off the  choosen option showing in the

choosen option list box 

for that clikced chart

now i have to that manualy