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: 
Not applicable

Display automatically data

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

1 Solution

Accepted Solutions
avinashelite

Please check the attachment

View solution in original post

13 Replies
avinashelite

Check the attachment for the solution

Not applicable
Author

Please check the attachment, Action needs to set up on text object on sheet one.

Not applicable
Author

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



avinashelite

could you please explain with screen shot how your excepting the output

Not applicable
Author

Attached

There are two options for the user.

avinashelite

Please check the attachment

Not applicable
Author

Thank you so much! exactly what I wanted

Not applicable
Author

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

avinashelite

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