topic Conditional display on straight table in QlikView

Conditional display on straight table

Anonymous — Mon, 28 Nov 2016 20:39:38 GMT

Hi ,

Below is my sample data.my requirement is if the end user selects a month,I want to display that month data and also data which is not associated to any month.(ex:if end user selects JAN then that should display JOBS 1,5,7).Any help is appreciated

JOB	MONTH	RESULT
1	JAN	10
2	FEB	15
3	NOV	11
4	DEC	35
5	NA	60
6	MAR	0
7	NA	0

Re: Conditional display on straight table

maxgro — Mon, 28 Nov 2016 20:50:09 GMT

maybe

only({$ <MONTH+={NA}>} RESULT)

Re: Conditional display on straight table

Anonymous — Mon, 28 Nov 2016 20:57:38 GMT

Thanks for your response,Actual data is NULL in the place of NA.Can you tweak that logic for NULL

Re: Conditional display on straight table

maxgro — Mon, 28 Nov 2016 21:22:26 GMT

only({ 1-<MONTH={*}>+<MONTH=P(MONTH)> } RESULT)