Display automatically data

[#1]

Hi community,

In my Qlikview document, I have created two sheets.

The first sheet contains "Text object".

The second sheet contains "Ad Hoc report"  -> Straight Table

Requirement is:

when the user selects the text object in sheet1,

I want him to move to sheet2 and automatically display the data in the Straight Table based on the column that I want to display

The column that I want to display when the user selects the text object:

Unique_num - From the Dimension list box

Source- From the Dimension list box

Amount $ - From the Metrix list box

also, i want to add another column "Count Unique Online", that will appear only when the user selects the text object,

I mean, the column will not be displayed in Metrix list box.

"Count Unique Online"  =Count({$<Source={"Online"}>}Unique_Num)

is there any way to build this report?

Attached is a sample report

[#2]

OK,

also, I want the user to move to sheet "Laed&Sale" when he selects the table box in sheet "Details".

[avinashelite]

Ok , I checked your doc .

You have added a conditional show for the sheet so you need to add one more action

Select in Field

Field : _Main_Menu_Desc

value: Leads & Sales

and promote it above the activation of the sheet..that will work

[#4]

It works, thanks!

[avinashelite]

cool mark all the helpful answers and close this thread