Yearly Archives: 2018

  also works If(=Min(TOTAL ) or =Max(TOTAL ),Black()) OR Pick(Match(, Max(Total ), Min(Total )),Blue(), Green()) (the last option gives you the choice of different colors) RudyK

Follow these steps to create a pie chart with staggered labels: 1. Create a new pie chart. 2. Add your dimension. 3. On the Expressions tab, add...

Introduction This document shows you how to include arrows on charts to compare year on year data. This technique is useful to compare increase or decrease...

The string function 'mid' has features similar to SQL substring function. An extract from the Qlikview Reference manual is below:   mid( s , n1  ) Substring of the string s....

=Age(Today(), CLT_DAT_NAISSANCE)

Date() is to format a number as date string / text, Date#() to interpret a string as date number.   Date#() is used how to interpret the data. ...

Transactions: SQL SELECT trn_uid, trn_no, trn_calendarDate, trn_fiscalDate FROM transact;   Temp: load max(trn_calendarDate) as maxCDate ,max(trn_FiscalDate) as maxFDate resident Transactions;   LET vMaxCal = peek('maxCDate'); LET vMaxFiscal = peek('maxFDate');   drop table Temp;

Check this OSuser( ) Returns a string containing the name of the current user as returned by the operating system. QVuser( ) Returns a string containing the name...

=num(count({<CANAL = {'SOSHCARAIBE'}, VALUE_INCLUDING_TAX={'sosh 4,99€','sosh 24,99€','sosh 34,99€'} >} ORDER_ID),'# ##0;(# ##0)')

Introdução Utilizar de recursos tradicionais para exibir informações de maneira personalizada pode adicionar maior valor agregado a forma como o usuário navega, analisa e toma...