Calendar selection in pivot table as Outlook calendar

[yoganantha321]

Hi all,

I have a master calendar and also a outlook calendar view in pivot table as shown in the image below:

If i select any particular date it is showing like 

But i need the output like the date selected must be highlighted like master calendars. Not as above..!

Any body can help in this!!!!!

Regards,

Yoganantha Prakash G P

[yoganantha321]

I have attached the sample file along with this for reference

[marcus_sommer]

You just need to ignore the selections within the expression, maybe with something like:

only({< Year =, Month =, Week, Day = >} Day)

and to highlight the selected values you could use an attribute-expression with something like:

count(Day)

- Marcus

[yoganantha321]

Hi marcus,

Can you share a sample file

[marcus_sommer]

Did you try it with my suggestion? It's not difficult ... just adjust the attachment.

- Marcus

[yoganantha321]

Hi marcus,

I tried it and its also affecting the table displaying the all the weeks in the month.

Yoganantha Prakash G P

[marcus_sommer]

Just take a look in the above attachment - it will work:

[yoganantha321]

Hi marcus,

I think my post was not clear.

If i selection is made on the pivot table , the selections affect the master calendar but the pivot table also got affected. But my expected output should be the selected date in the pivot table must be in different color like outlook calendars selection. 

[marcus_sommer]

In the example I just set the background-color to grey - you could adapt the logic to color the font-color like you want.

- Marcus

[yoganantha321 · Accepted solution]

Got Solution with the reference:

https://community.qlik.com/t5/QlikView-Documents/Creating-a-Custom-Calendar/ta-p/1476790

PFA