Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kkoyyalamudi
Creator
Creator

Conditional display on straight table

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

  

JOBMONTHRESULT
1JAN10
2FEB15
3NOV11
4DEC35
5NA60
6MAR0
7NA0
1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

1.png

View solution in original post

3 Replies
maxgro
MVP
MVP

maybe

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

1.png

kkoyyalamudi
Creator
Creator
Author

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

maxgro
MVP
MVP

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

1.png