Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
OK,
also, I want the user to move to sheet "Laed&Sale" when he selects the table box in sheet "Details".
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
It works, thanks!
cool mark all the helpful answers and close this thread