Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
panipat1990
Contributor II

LOGIC

Dear Team,

I Stuck a issue.i have one table where three date's fields exists. i want to combine these three  Date field's and make them on common field where exist all dates.one approach i used three times load same table and create flag for recognising field.instead of this approach,

another approach i want to used.suppose my qvd size 4 gb then i cannot three times load.because application will be increase.kindly tell me for relosolvig this issue.

for this i am sharing table.i want to create a new field where combination of three dates.i Want to In frontend Pass Flag i expression Find The Res

5 Replies
ahaahaaha
Honored Contributor

Re: LOGIC

Hi Gourav,

Look here  Canonical Date . Maybe this is what you need.

Regards,

Andrey

panipat1990
Contributor II

Re: LOGIC

Can you send me one qvw for example of canonical date.where 3 transaction and 1 transaction contain multiple date

sanjay006
Contributor

Re: LOGIC

gGaa

sanjay006
Contributor

Re: LOGIC

Gourav refer the above file attached.

panipat1990
Contributor II

Re: LOGIC

Dear Sanjay,

Can you send me a qvw multiple dates in one table.not different different table.Suppose in my table three dates ..then how to make one date Combination of three dates.For this i already shared data in above attachment. Kindly help me