Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a list box
and a Pivot Table:
Could you help me, that I get this view (customer 1 is active)
if the customer 2 in the listbox is active, the pivot showing the amount and the customer 2 view.
Could you help me to solve this problem.
Go to Solution.
The Values Present in the ListBox for Customer1 and Customer2 so use the same text in the Expression mentioned below .
I see at present the text in the ListBox is "Customoer 1" but we gave solution with the text as "Customer1" .
So include the text "Customer 1"(Same as present in the ListBox ) in the Expression below,
= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer 1'))
and for Customer2 conditional expression
= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer 2'))
Please let me know if there is anything .
You can try this.
=SubStringCount(Concat(listbox,'|'),'customer2 ') in Expression tab conditional
Try to have the Expression in the Conditional Box of each Expression
for column Customer1 confditional
= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer1'))
= if(IsNull( GetCurrentSelections()) ,0,SubStringCount(GetCurrentSelections(), 'Customer2'))
sorry it doesn't work, where is the expressio tab, where can i find it?
it doesn't work, it shows only a 0 in the column. If I click one of the listbox, the other column is visible.
Do you know why?
Go to your pivot table properties > Expression Tab in the top right corner check conditional and then paste the the expression for each Expression like.
Also find the attachment for more detail.