RSS
 

PDF Distribution with no reduce using QlikView Publisher

30 Sep

A while ago, I needed to publish pdf to each team leader which include some Share Ratio KPIs.

Since to calculate the share ratio, all other teams’ data must be in whole data. QlikView Publisher module loops in a field but also reduces the whole data with each selection. So that reduced data includes only one teams data, then share ratio is always calculated as 100%

One guy has faced the same issue and posted to Qlik Community, I asked him also but he said that “Contacted Qliktech support / account manager and a QlikTech consulant, however no resolution within Qlikview.”

Also he suggested, “The only solution provided for showing the regional / national numbers was to build a additional table with this data snowflaked from the original data.”

This solution is a little tricky but it works… Here is how I did it;

There is a table in my model named TEAM. I need to loop each team without reducing data, so that I created a new table named TEAM_PUB which also stores all team info. This new table must have no relation any other tables in the model, this is very critical! As you can see below;

qv_pub_table

Now, you have to loop the field of this _PUB table over Publisher…

qv_pub_loop

These operations are not enough, you have to prepare a new pdf Report on QlikView Desktop application. You have to change the expressions of the charts which are used in this new pdf. You can check how to change the expressions in the following scripts;

Old version: “Sum(Sales.Amount)”

New version: “Sum({<TEAM.CODE={‘$(=Only(TEAM_PUB.CODE))’}>} Sales.Amount)

Publisher will loop on each value of the field “TEAM.CODE” so that “=Only(TEAM_PUB.CODE)” will always return 1 value.

The only disadvantage of this solution is that Publisher works slower than the reducing version. This is because of pdf is created on whole data. Also the temp files of Publisher are much more bigger.

But it worths, in some cases it saves life! :)

 

Social Share Toolbar
 
No Comments

Posted in QlikView

 

Odeabank İş Zekası Ropörtajı (IT Network)

26 Jan

“QlikView tercihimizin ne kadar doğru olduğunu geri dönüşlerden anlıyoruz…

IT Network – 15 Aralık 2013

 

ITNetwork_1 ITNetwork_2 ITNetwork_3

Social Share Toolbar
 
No Comments

Posted in Türkçe

 

Sapanca Migros

25 May

Simdiye kadar gördügüm en kücük ve sirin Migros

20130525-212327.jpg

Social Share Toolbar
 
No Comments

Posted in Türkçe

 

Odeabank İş Zekası Ropörtajı (BT Haber)

24 Dec

“Bankacılıkta uçtan uca teknoloji farkı”

BT Haber - 24 Aralık 2012

 

BTHaber_1 BTHaber_2

 

Social Share Toolbar
 
No Comments

Posted in Türkçe

 

Check domain availability in a safe way

06 Dec

Many domain whois checker sites log the domain names and sell it to the 3rd parties.

So the safest way to check the domain name availability, is doing it from your computer! No logging, no need to be paranoid :)

For Windows:

Open Command Prompt Run nslookup -type=ns domain.com, if it lists the nameservers, domain is not available

For Linux, *BSD or Mac OS X:

Just run whois domain.com

Social Share Toolbar
 
 

Banking Terms Acronyms

06 Nov
LC   : Letter of Credit
LG     : Letter of Guarantee
SME    : Small and Medium Enterprises
SBB    : Small Business Banking
RTL    : Retail
NPL    : Non Performing Loans
LCY    : Local Currency
FCY    : Foreign Curreny
NII    : Net Interest Income
YTD    : Year to Date
RM     : Relationship Manager
PN     : Promissory Note
ROA    : Return On Assets
ROE    : Return On Equity
IEA    : Interest Earning Assets
OPEX : Operating Expenses
CAPEX: Capital Expenditure
Social Share Toolbar
 

Banka Mizan tablosundan Bilanço çıkarma

02 Nov

Bankacılık mizan tablosunda DK (Defteri Kebir) ile Bilanço rakamlarını çıkarmak için aşağıdaki DK numaraları ile başlayan kayıtlar üzerindeki bakiyelerin toplamını almak gerekiyor.

DK BİLANÇO
0 Likit Aktif
1 Krediler
2 Diğer Aktifler
3 Mevduat ve Yabancı Kaynaklar
4 Özkaynaklar
0-1-2 Aktif
3-4-5-6-7-8 Pasif
5-6-7-8 Dönem Karı
5-7 Gelir
6-8 Gider
5 Faiz Geliri
6 Faiz Gideri
7 Faiz Dışı Gelir
8 Faiz Dışı Gider
9 Bilanço Dışı Hesaplar
Social Share Toolbar
 

MS SQL Server sp_MSforea​chdb usage

07 Oct

This is a system SP for looping a command in all databases in a server.

Question mark is used for DB name.

Following query selects DB name and the number of tables of each DB;

DECLARE @command VARCHAR(1000) 
 
SELECT @command = 'USE ? select ''?'', count(1) from sysobjects where xtype = ''U'''
--U for tables, V for views
 
EXEC sp_MSforeachdb @command
Social Share Toolbar
 

Büyümüs de babasina cicek gönderirmis

17 Sep

image

image

Mobil yükleme

Social Share Toolbar
 
No Comments

Posted in Türkçe

 

Dropbox ile mobil fotoğraf ve videolarınızı ücretsiz yedekleyin

28 Jul

Cep telefonunuzdaki fotoğraf, video ve diğer dosyalarınızı en son ne zaman yedeklediniz? Şu an cep telefonunuzun başına birşey gelse ve tüm dosyalarınızı kaybetseniz.

Dropbox bu gibi kayıplara uğramamanız için tasarlanmış bir program. Android ve Iphone uygulamaları mevcut. Ayrıca PC’ye de kurulabilen bir programı var. Cebinizde çektiğiniz bir fotoğraf otomatik olarak Dropbox alanınıza yükleniyor, oradan da PC’nizde belirlediğiniz klasöre otomatik indiriliyor.

Üstelik, yedekleme işkencesinden kurtaran bu program ücretsiz. 2 GB’a kadar ücretsiz alan veriyor. Fazlasını isterseniz ücret ödemek zorundasınız ki 2 GB bence yeterli bir miktar.

Dropbox ücretsiz üyelik için tıklayın

Social Share Toolbar