topic Re: qlik requirement in QlikView

qlik requirement

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team, please help me with the below requirement i have sample data shown below Material , WeekOfCaptureDate , key R6H60A ,2020/21, 1 R6H60A ,2020/20, 1 R6H60A ,2020/19, 1 R6H60A 2020/22 1 R6H60A 2020/22 1 R6H60A 2020/15 1 R6H60A 2020/16 1 R6H60A 2020/19 1 SN500-00192 2020/14 2 SN500-00192 2020/15 2 SN500-00192 2020/15 2 SN500-00194 2020/15 2 SN500-00194 2020/15 2 SN500-00194 2020/16 2 SN500-00194 2020/16 2 SN500-00194 2020/17 2 i have to show only last 4 weeks in pivot table (i,e 2020/22,2020/21,2020/20,2020/19) dimension: material,WeekOfCaptureDate ---(week column) measures: count(key) Thanks siva

Re: qlik requirement

Taoufiq_Zarra — Tue, 16 Jun 2020 13:50:04 GMT

@siva8

as I understand it, you have this sample data that I added the makeweekdate function to return a date.

Data: load *,makeweekdate(left(WeekOfCaptureDate,4),mid(WeekOfCaptureDate,index(WeekOfCaptureDate,'/')+1)) as DateWeek inline [ Material , WeekOfCaptureDate , key R6H60A ,2020/21, 1 R6H60A ,2020/20, 1 R6H60A ,2020/19, 1 R6H60A ,2020/22, 1 R6H60A ,2020/22, 1 R6H60A ,2020/15, 1 R6H60A ,2020/16, 1 R6H60A ,2020/19, 1 SN500-00192 ,2020/14, 2 SN500-00192 ,2020/15, 2 SN500-00192 ,2020/15, 2 SN500-00194 ,2020/15, 2 SN500-00194 ,2020/15, 2 SN500-00194 ,2020/16, 2 SN500-00194 ,2020/16, 2 SN500-00194 ,2020/17, 2 ];

with this I can go through the last four weeks by the max function.

So for pivot Table :

Dimension :

Materiel
WeekOfCaptureDate

Measure :

count({<DateWeek={">=$(=Max(DateWeek,4))"}>} key)

the output :

attached qvw file

Re: qlik requirement

siva8 — Tue, 16 Jun 2020 13:51:22 GMT

HI Team ,

the above post was not clear, so here i am attaching the sample data

Hi Team,
please help me with the below requirement

i have to show only last 4 weeks in pivot table ((i,e 2020/22,2020/21,2020/20,2020/19) )
dimension: material,WeekOfCaptureDate (week column)
measures: count(key)

please find the attached and sample data

Thanks
siva

Re: qlik requirement

Taoufiq_Zarra — Tue, 16 Jun 2020 13:59:18 GMT

@siva8 Did you check my post ?

Re: qlik requirement

siva8 — Fri, 19 Jun 2020 18:05:36 GMT

Hi Taoufiq,

Thanks for your prompt response , its working fine as expected ,

i have another requirement here -- if user select a particular week in list box( for example i .e 2020/15,2020/16) that time the chart should render based on the selection they made .if nothing is selected chart should show only last 4 weeks.

Thanks

siva

Re: qlik requirement

Taoufiq_Zarra — Fri, 19 Jun 2020 18:38:30 GMT

Hi @siva8

attached new version :

with selection

no Selection :

Re: qlik requirement

siva8 — Sat, 20 Jun 2020 07:59:18 GMT

@Taoufiq_Zarra

Thank you its working

Thanks

siva