Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
singhcv123
New Contributor II

don't want to show same period last year data in a different column

Hi,

I am using pivot table and calculating current,previou and same period last year data in table.

as given in below screenshot i want the data in financial year 2016 not in 2015 ... because i selected 2016 in list box...

what to do .

Set expression for :

This Period :sum(Count)

Previous PeriodSmiley Frustratedum({<[New Period Code]={$(=if([New Period Code]=1,13,[New Period Code]-1))}>}Count)

Same Period Last Year Smiley Frustratedum({$<[New Period Code]={$(=Num([New Period Code]))},[Financial Year]={$(=NUM([Financial Year])- 1)}>}Count)

please suggest.

screenshot.png

2 Replies
MVP
MVP

Re: don't want to show same period last year data in a different column

Provide data to work !

MVP
MVP

Re: don't want to show same period last year data in a different column

Two ways are there I can suggest.

  •      In the script, create another column with last year data. Check :The As-Of Table for idea.
  •      In the UI, use pick()/match(), possibly in combination with synthetic dimension Valuelist()/Valueloop()

Both the ways have their pros and cons.

Community Browser