topic Display automatically data in QlikView

Display automatically data

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Display automatically data

avinashelite — Tue, 27 Jun 2017 10:02:53 GMT

Check the attachment for the solution

Re: Display automatically data

Tue, 27 Jun 2017 10:20:42 GMT

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

Re: Display automatically data

Tue, 27 Jun 2017 10:49:07 GMT

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

Re: Display automatically data

avinashelite — Tue, 27 Jun 2017 10:52:01 GMT

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

Re: Display automatically data

Tue, 27 Jun 2017 11:05:38 GMT

Attached

There are two options for the user.

Re: Display automatically data

avinashelite — Tue, 27 Jun 2017 11:40:18 GMT

Please check the attachment

Re: Display automatically data

Tue, 27 Jun 2017 11:46:07 GMT

Thank you so much! exactly what I wanted

Re: Display automatically data

Tue, 27 Jun 2017 14:15:30 GMT

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

Re: Display automatically data

avinashelite — Wed, 28 Jun 2017 11:16:36 GMT

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

Re: Display automatically data

Wed, 28 Jun 2017 11:27:55 GMT

OK,

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

Re: Display automatically data

avinashelite — Wed, 28 Jun 2017 11:50:32 GMT

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

Re: Display automatically data

Wed, 28 Jun 2017 11:52:17 GMT

It works, thanks!

Re: Display automatically data

avinashelite — Wed, 28 Jun 2017 12:00:19 GMT

cool mark all the helpful answers and close this thread