topic Re: Calculated Condition on Pivot table in QlikView

Calculated Condition on Pivot table

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

Hi,

I would like my pivot table to be hidden, until the user selects a date from a Listbox and a Hour from another Listbox.

Can anyone assist? How do you refer to objects states as a calculated condition?

Thanks in advance.

Regards,

Re: Calculated Condition on Pivot table

marcus_sommer — Mon, 18 Jul 2016 07:41:45 GMT

Put an expression like the following into the calculation-condition from the pivot within the object-properties in tab general:

if(getselectedcount(Date) = 1 and getselectedcount(Hour) = 1, true(), false())

- Marcus

Re: Calculated Condition on Pivot table

Anonymous — Mon, 18 Jul 2016 07:44:48 GMT

Thanks, worked perfectly !

Re: Calculated Condition on Pivot table

bvssudhakar — Wed, 28 Mar 2018 09:09:19 GMT

Hi Marcus,

I have one requirement, here i attached one qvw file in that file

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12

But output is not showing like this, it is showing selections related 572 rows some thing

Give some suggestions to out from this situation

Thank you in advance

Sudhakar

Re: Calculated Condition on Pivot table

marcus_sommer — Wed, 28 Mar 2018 14:29:33 GMT

You are using multiple alternate states and your objects seems not to be in these states which you think they are. I suggest to re-thing your whole approach because I have the impression that it is too complex and overused.

- Marcus