Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

9 Replies
PrashantSangle

can you provide us sample input data???

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anil_Babu_Samineni

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 ?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

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

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Can anyone help me with attached sample data.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Creator III
Creator III

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
Author

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.

  

Anonymous
Not applicable
Author

I have added sample data and screenshot as an attachment