Discussion board where members can get started with QlikView.
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.
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())
View solution in original post
Thanks, worked perfectly !
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
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
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.