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
Please check the attachment
Check the attachment for the solution
Please check the attachment, Action needs to set up on text object on sheet one.
Thanks,
but I have a problem with displaying the column "Count Unique Online"
I don't want to display this column when the user selects fields from the ad hoc report,
I want to display this column only when the user selects the text object
could you please explain with screen shot how your excepting the output
Attached
There are two options for the user.
Please check the attachment
Thank you so much! exactly what I wanted
Hi Avinash,
I'm trying to implement your help on my real project, but it's not working.
can you please see what I am doing wrong
Ok , as per my last attachment 2 things are missing
1.Additional expression
2.inline table to select the expression
LOAD * Inline
[
Select
Unique
];
3.Add to add all the actions