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

Calculated Condition on Pivot table

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,

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

4 Replies
marcus_sommer

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

Anonymous
Not applicable
Author

Thanks, worked perfectly !

bvssudhakar
Creator III
Creator III

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

     

24222/16/2012Baby ClothesAino ShoesHalle KölnBob Park41
24222/16/2012Baby ClothesDeuce ShirtHalle KölnBob Park11
46651/21/2013Baby ClothesAino ShoesLa Moda d'il FuturiRicardo Gucci61
46651/21/2013Baby ClothesDeuce ShirtLa Moda d'il FuturiRicardo Gucci12

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

marcus_sommer

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