topic Re: Need help in tabular report in QlikView

Need help in tabular report

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to display report in tabular format. I have two dimension (A and B).

I have marked in color code. Amber color will not change it should static and if i select A then corresponding data will display. Similar way for column B.

Output format mentioned in sheet 2

Re: Need help in tabular report

PrashantSangle — Tue, 08 Aug 2017 11:59:21 GMT

can you provide us sample input data???

Regards,

Prashant

Re: Need help in tabular report

Anil_Babu_Samineni — Tue, 08 Aug 2017 12:07:44 GMT

Even, this should work default. I don't think whether you need any changes here

And try BG color for A dimension and try with selection then see ?

Re: Need help in tabular report

Anonymous — Tue, 08 Aug 2017 12:22:56 GMT

I don't required color. Just wanted to show in sheet 2 format

Re: Need help in tabular report

PrashantSangle — Tue, 08 Aug 2017 12:32:31 GMT

Hi,

Create Flag in your script and use it in your front end

for example

Load Area,Component,A as data,'A' as Flag from table;

concatenate

Load Area,Component,B as data,'B' as Flag from table;

In front End

take Pivot table

add dimension Area, component

Expression only(data)

take Filter in front end : Flag

Regards,

Re: Need help in tabular report

Anonymous — Mon, 14 Aug 2017 08:03:27 GMT

Can anyone help me with attached sample data.

Re: Need help in tabular report

Anil_Babu_Samineni — Mon, 14 Aug 2017 08:06:16 GMT

What is the diff between first sheet and second sheet for first three columns?

Can you make it clear in image where we have to look

Re: Need help in tabular report

d_prashanthredd — Mon, 14 Aug 2017 08:36:09 GMT

You can do that in straight table also or in any other chart.

I'm assuming that your table should have Area and Component and 3rd dimension as A or B based upon the user selection.

First load two flags in a script.

FieldSelection:

load * inline [

FieldValue

ReportBy_A

ReportBy_B

];

Then in front end have a list box/filter with FieldValue

Place a table --> Add dimensions Area, Component and 3rd one should be a calculated dimension

if(GetFieldSelections(FieldValue) = 'ReportBy_A', A,

if(GetFieldSelections(FieldValue) = 'ReportBy_B', B, A)

)

Then by default your report will show data for A and changes accordingly on selection of B or A.

Thanks,

Prashanth.

Re: Need help in tabular report

Mon, 14 Aug 2017 09:09:03 GMT

Try like this

crosstable(select,data,2)

load

Area,

Component,

from book1.xlsx;

Then create pivot table

Give

Area,

Component,

and selectas dimensions

and give data as expression

then drag select from vertical to horizintal,

Note:select is a fields name give name with your convenient name.

Re: Need help in tabular report

Anonymous — Mon, 14 Aug 2017 14:25:18 GMT

I have added sample data and screenshot as an attachment