topic Re: How to implement calendar objects in QlikView

How to implement calendar objects

karunaramteke — Tue, 01 Dec 2020 17:05:46 GMT

Hi all,

I have a date column (Complete.postingDate)

I want to implement calendar object in it min and max Date.

I have tried using variable and gave min and max range ., however that is not reflecting my chart object.

Please help.

Please find attached reference qvw sheet3.

Thanks in advance.

Re: How to implement calendar objects

edwin — Tue, 01 Dec 2020 17:14:57 GMT

@karunaramteke - there is no attached QVW. can you pls re attach?

Re: How to implement calendar objects

karunaramteke — Tue, 01 Dec 2020 17:17:09 GMT

Re: How to implement calendar objects

karunaramteke — Tue, 01 Dec 2020 17:44:47 GMT

Can anybody please help me to get calendar object.

Re: How to implement calendar objects

edwin — Tue, 01 Dec 2020 21:44:18 GMT

is your problem min and maximum showing number? in the top 2 objects?

date is a dual type (meaning it has text (this is the format you see like MM/DD/YYYY). min function returns a number so just use the date function

date(min(dateField))

Re: How to implement calendar objects

karunaramteke — Wed, 02 Dec 2020 01:27:03 GMT

No it turns into number . I tried it.

In one calendar obj I want to select date

eg: 01-10-2020 and in other calendar obj I want to select 31-10-2020.

Re: How to implement calendar objects

MayilVahanan — Wed, 02 Dec 2020 05:43:32 GMT

Hi @karunaramteke

For your case, you need to use trigger . PFA

Actually, am not sure why you are using table box instead of straight table.

Alternate, If you are using the straight table, you can use set analysis instead of trigger.