Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Creator III
Creator III

Thanks, worked perfectly !

Highlighted
Creator II
Creator II

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

MVP & Luminary
MVP & Luminary

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