Crosstabular Display in Qlikview

[mhmmd_srf]

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

[Anil_Babu_Samineni · Accepted solution]

Yes, That is possible. Look here

Redefining the Week Numbers

And Change Cross dimension to vertical values from Presentation

[mhmmd_srf]

Hi Anil,

In presentation I am getting this only.

[Anil_Babu_Samineni]

Go to Object presentation like below

[mhmmd_srf]

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

[Anil_Babu_Samineni]

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

[mhmmd_srf]

Thanks a lot Anil Sir..

I think I am able to make...

Thanks again...

Will let you know the updated status..

Thanks,

Sarif