topic Re: Customized Report in QlikView

Customized Report

Tue, 14 Jun 2016 18:03:23 GMT

Hi Folks,

I am trying for customized report, its not working.

Please look into it and help

PFA

sub2u444‌

Script:-

DimensionList:

LOAD * INLINE

[

dimension_1,dimesnion_flag

Name,1

Country,2

Job,3

];

LOAD * INLINE [

Parameter_1, Parameter_flag

Salary, A

Taxes, B

];

Data:

LOAD * INLINE

[

Name,Country,Job,Salary,Taxes

Philip Lawrence,USA,Teacher,35000,2000

John Schummacher,Germany,IT Consultant,42000,3500

Albert Casanella,Spain,Salesman,52000,5000

Alexander Xiao,Hongkong,Doctor,48000,4400

Ayax Smart,England,IT CEO,80000,7000

];

Re: Customized Report

sunny_talwar — Tue, 14 Jun 2016 18:30:08 GMT

Check the attached

Re: Customized Report

Wed, 15 Jun 2016 01:52:34 GMT

Hi Sunny,

Thanks for the reply.

If i won't select any dimension, default dimension "Country" and Measure "Salary".

PFA snippet.

Thanks in advance.

sub2u444‌

Re: Customized Report

sunny_talwar — Wed, 15 Jun 2016 02:45:43 GMT

Check now

Re: Customized Report

Wed, 15 Jun 2016 03:09:40 GMT

Thanks a ton for the reply.

Its working fine Sunny.

Re: Customized Report

sunny_talwar — Wed, 15 Jun 2016 03:11:53 GMT

I am glad I was able to help. Please close the thread if you got what you wanted

Re: Customized Report

Wed, 16 Nov 2016 11:07:23 GMT

Hi Sunny,

Is it possible to create a likewise customized report but based on variables? Instead of fields.

Br,

Mathias

Re: Customized Report

sunny_talwar — Wed, 16 Nov 2016 11:26:35 GMT

Would you be able to provide a sample to show what you are trying to do?

Re: Customized Report

Wed, 16 Nov 2016 13:11:42 GMT

Hi Sunny,

I would like to add fields to customized table builder.

But I want this list of fields split up. For example between dates and normal fields. Another example of such a split up could be dimensions and expressions.

Just like in attachment I also don't want this to be added to the current selections.

Thanks in advance!

Br,

Re: Customized Report

sunny_talwar — Fri, 18 Nov 2016 02:49:09 GMT

So dimensions should be select-able from two different list box? Is that what you are looking to achieve here? I am not 100% sure I understand what you mean by split-up here.

Re: Customized Report

Fri, 18 Nov 2016 07:33:34 GMT

Yes that's the intention. To select the dimensions of the table builder from 2 list boxes.

Now it is not possible to select different dimensions in the different list boxes.

Br,

Re: Customized Report

sunny_talwar — Fri, 18 Nov 2016 11:43:20 GMT

Try this with two different inline loads

LET HidePrefix = '%';

Fieldlist1:

LOAD * INLINE [

%Field,%Field_Explanation

Surname, First Name salesman

Name, Second Name salesman

Country, Country salesman

TotalSold, Total amount of Sales

];

Fieldlist2:

LOAD * INLINE [

%DateFields, %Date_Explanation

Birth date, birth date salesman

DateFirst, Date first Sale

DateLast, Date last Sale

];

Data:

LOAD * INLINE

[

Surname,Name,Country,Birth date,TotalSold,DateFirst,DateLast

Mark, Lawrence,USA, 03-03-1965, 35000, 02-02-2016, 15-10-2016

Kevin, Schummacher,Germany,12-02-1985 ,42000, 05-10-2010, 15-10-2016

Bert, Cast,Spain,23-03-1970,52000, 02-11-2005, 15-11-2016

Alex, Ho,Hongkong,14-06-1975,48000, 22-03-2012, 05-10-2016

Max, Best,England,20-09-1980,80000, 06-08-2014, 15-08-2016

];

So now you can see that you can select in both the list boxes at the same time. In addition, current selection is not showing those selections because of my use of HidePrefix (Read about HidePrefix – hiding fields here).

HTH

Best,

Sunny