Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
suman_dhar
Creator
Creator

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.
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 ?

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
Creator
Creator
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.
suman_dhar
Creator
Creator
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

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

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

I have added sample data and screenshot as an attachment