topic Re: input box and pivot table in QlikView

input box and pivot table

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

i have an input box with variable 'vperiod' predefined values to drop down ytd;qtd

and whenever input box is changed to 'qtd' from input box

pivot table is changing accordingly and getting results

can someone explain how pivot table giving results based on selections in input box

Re: input box and pivot table

marcus_sommer — Fri, 02 Jun 2017 07:23:24 GMT

Take a look within the pivot-expression - there will be this variable included - it could be also that this variable is included into anther variable. This meant you need to check all variables.

- Marcus

Re: input box and pivot table

Sergey_Shuklin — Fri, 02 Jun 2017 07:53:34 GMT

Hello, Suresh!

If your pivot table has this expression: sum({<period={"$(vperiod)"}>}sales) it will show result depend on variable value.

Re: input box and pivot table

stonecold111 — Fri, 02 Jun 2017 08:25:30 GMT

but it is not used in expression

or other variables

just in layout tab . conditional expression

Re: input box and pivot table

marcus_sommer — Fri, 02 Jun 2017 08:33:06 GMT

This meant there are several different objects with different expressions and their visibility is controlled through this variable. I think I would rather not use this kind of usability and putting this visibility-conditions in a single object (each expression could be controlled in the same way) or I would use a container for the different objects but if your solution worked you don't need to change it (and now you know what happens and could adjust it if necessary).

- Marcus

Re: input box and pivot table

Sergey_Shuklin — Fri, 02 Jun 2017 08:33:12 GMT

As far as I know Layout tab is containing only condition to show/hide object. You want pivot table to appear during variable changes?

Re: input box and pivot table

stonecold111 — Fri, 02 Jun 2017 08:38:41 GMT

yes you both are right..

but i cannot mark as both correct answer. so for the first one

Thanks a lot. serj_shu marcus_sommer