topic Re: Show a Table in QlikView

Show a Table

priya945 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have below data

Emp	Country	Region	Month	Sales
Ram	India	APAC	Jan	200
Raj	UK	Europe	Jan	100
Ram	India	APAC	Feb	300

Created a pivot table as below

	APAC
Emp	Jan	Feb
Ram	200	300

When clicking on APAC then need to show country values (dynamically) in same table

	APAC		India
Emp	Jan	Feb	Jan	Feb
Ram	200	300	200	300

Thanks In advance,

Priya

Re: Show a Table

neelamsaroha157 — Thu, 05 Jul 2018 17:52:09 GMT

Create a drill down down group and use the drill down group in dimension.

Re: Show a Table

priya945 — Fri, 06 Jul 2018 02:37:22 GMT

HI Neelam

I need to display the column(India) dynamically when user selects on APAC

Thanks

Re: Show a Table

priya945 — Wed, 11 Jul 2018 06:30:24 GMT

Hi,

I have managed to show the expression dynamically using GetFieldSelections function.

But the requirement is to show below

Now the field Country contains only India as Region and if China is added later then instead of writing the expression manually for each region, can we write one expression that dynamically read the values from the field Region to form the expression for each region

Can this be done in UI or Load script?

Thanks ALL.

Re: Show a Table

priya945 — Wed, 11 Jul 2018 10:02:05 GMT

H All,

Any suggestion please?

Regards,

Priya

Re: Show a Table

neelamsaroha157 — Wed, 11 Jul 2018 15:55:17 GMT

For the output like your last table, what I would do is - Use EMP and Country as dimension in a pivot table and use set analysis for 'APAC'. Something like Sum({<Region = {'APAC'}>}Sales).

it would be more helpful if you can share a sample qv file.

Re: Show a Table

neelamsaroha157 — Wed, 11 Jul 2018 16:04:33 GMT

Check this out.

You can play play around the 'Total' display depending on how you want it.

You can also use the below expression if you are looking to make changes only for APAC-

=If(GetFieldSelections(Region)= 'APAC', 'APAC', 'TOTAL')

Re: Show a Table

priya945 — Thu, 12 Jul 2018 08:11:05 GMT

Thank you Neelam for the suggestion.

I agree with the expression if user select on APAC, below expression works.

=GetFieldSelections(Region)= 'APAC'

But Region Listbox has APAC, EUROPE, USA...and when user makes a selection on the Region ListBox(EUROPE/USA) then Pivot table has show the countries belongs to dynamically

I think a variable to read the user input may help. please suggest

Re: Show a Table

neelamsaroha157 — Thu, 12 Jul 2018 12:57:39 GMT

Hi Priya,

Thanks exactly what is QVW is doing.

Can you specifically tell me whats not working in the attachment?

Re: Show a Table

priya945 — Fri, 13 Jul 2018 06:23:24 GMT

Thank you Neelam .

Finally i achieved the output

Re: Show a Table

qlikviewwizard — Fri, 13 Jul 2018 06:45:13 GMT

priya945‌

Please select Correct Answer and close the thread.