Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display data according D and D-1

I developed a dynamic array with two dimensions:
Site and date
plus two expressions:
- The first one calculates KPI "PMC" on the selected date
- And the other computes a KPI "PMC" whichever "selected day-1"

calculates is correctly but the display is not as good.

what i got
Site           !       Date         !      Ending
PMC  !       Begin PMC
France       !       Total         !          239674      !         239839
France       !   
08/23/2012   !         239 674      !            0                 
France       !   
08/24/2012   !              0          !         239 839

what I'm looking for

Site           !       Date         !      Ending PMC  !       Begin PMC
France       !       Total         !          239674      !         239839
 
France       !   
08/24/2012   !         239 674      !        239 839

Why is the date D-1 is displayed?? it gives me 0, for the user is false data. I'm looking to display only KPI for the selected date ....!


what should I do?


Thank you.

3 Replies
MayilVahanan

HI

     Try like this,

     =if(calculatesKPI"PMC"on the selected date > 0 ,

calculates KPI "PMC" on the selected date)

and for second expression  also..

Hope it helps..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

do you know a function like LAG in SQL ?????

in my exemple, idont want to see the line with date = 08/23/2012 , beacause i did a selction on 08/24/2012.

Thx.

jvitantonio
Specialist III
Specialist III

You might be missing something. Can you attach your applicatino? (just the part that you need for this example)