Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
suman_dhar
Contributor

Need help in tabular report

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

Tags (1)
9 Replies

Re: Need help in tabular report

can you provide us sample input data???

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.

Re: Need help in tabular report

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 ?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
suman_dhar
Contributor

Re: Need help in tabular report

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

Re: Need help in tabular report

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,

Great dreamer's dreams never fulfilled, they are always transcended.
suman_dhar
Contributor

Re: Need help in tabular report

Can anyone help me with attached sample data.

Re: Need help in tabular report

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
d_prashanthredd
Contributor III

Re: Need help in tabular report

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.

Not applicable

Re: Need help in tabular report

Try like this

crosstable(select,data,2)

load

Area,

Component,

A,

B

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.

  

suman_dhar
Contributor

Re: Need help in tabular report

I have added sample data and screenshot as an attachment