topic Re: Crosstabular Display in Qlikview in QlikView

Crosstabular Display in Qlikview

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

Hi All,

I need below kind of structure.

In the column level we need to show week. Lets say first column is week 8. 19th Feb 2017 to 25th Feb 2017.

1. I need to show values only from Monday to Friday.

2. In the display the week will show the Last day(Friday) of the week. Like for 8th week, it will show 24Feb.

We have a flag called WeekEndFlag. If I select Flag =1, the it only shows Mon to Fri. But in Display level how to handle.

Please help.

Thanks,

Sarif

Re: Crosstabular Display in Qlikview

Anil_Babu_Samineni — Tue, 28 Feb 2017 03:12:17 GMT

Yes, That is possible. Look here

Redefining the Week Numbers

And Change Cross dimension to vertical values from Presentation

Re: Crosstabular Display in Qlikview

mhmmd_srf — Tue, 28 Feb 2017 03:19:16 GMT

Hi Anil,

In presentation I am getting this only.

Re: Crosstabular Display in Qlikview

Anil_Babu_Samineni — Tue, 28 Feb 2017 03:25:15 GMT

Go to Object presentation like below

Re: Crosstabular Display in Qlikview

mhmmd_srf — Tue, 28 Feb 2017 03:56:39 GMT

Hello Anil Sir,

My original Object is looks like this:

Now I want to the last Weekday instead of 41,42...

Please help.

Thanks,

Sarif

Re: Crosstabular Display in Qlikview

Anil_Babu_Samineni — Tue, 28 Feb 2017 04:34:07 GMT

Cool, Some what you have prove on wall with Image.

Now, Coming to Week theory. What was the issue you are facing here. Which year of week these are? Is that possible to share Application and mean time can you look my URL which i shared earlier to you

Re: Crosstabular Display in Qlikview

mhmmd_srf — Tue, 28 Feb 2017 07:00:11 GMT

Thanks a lot Anil Sir..

I think I am able to make...

Thanks again...

Will let you know the updated status..

Thanks,

Sarif