topic Re: fix the selection in QlikView

fix the selection

Wed, 26 Jun 2013 06:43:38 GMT

AOA grus

i have table as follow

with three dimension

complaint_no	category	current staus	days

abc	networking	in progress	10
cde	networking	pending	5
efg	networking	pending	2
hij	networking	Resolve	2

i want to show another table only showing pending complaints

complaint_no	category	current staus	Reason	days
cde	networking	pending	Short of Inventory	5
efg	networking	pending	short of man power	2

so how to fix the 2nd table to only show pending complaint so if clear all field its stick to only pending...

alexandros17 — Wed, 26 Jun 2013 06:50:57 GMT

Set in the dimension:

if(current_status='Pending, Current_status, null())

and check "exclude null values"

Hope it helps

neetu_singh — Wed, 26 Jun 2013 07:06:44 GMT

Hi,

In Dimension Tab,

Click on "Add Calculated Dimension" Button and write the below mention expression as:

= If(current status = 'pending',current status)

Check the check box for "Suppress Null Value".

Regards

Neetu