Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help I'm new to qlikview and I'm trying to creat a dashboard using the pivot table. I have the info I need I just need to be able to select the info by week. Anyone have any ideas? I was told to use the WEEKEND command, but I can't get it to work. Any help would be great.
Hello,
Create a new calculated dimension as
in your graph and create a new listbox with same formula so you can see all weeks and select them.Week(YourMainDateField)
Regards.
(Yourmaindatefield) ? would that be my column that has the date?
Or would it be the actually date I want this to begin?
Hello, meaning the field where you store the date which weeks you want to use.