Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone I am new user in Qlik Sense.
I have prepare 5-6 dashboard using there are three table card_detail, card_status and transaction_detail. each table has there own dates.
1) card_detail table has insert_date which is used to find number of account created.
2) Card_status has the modified data which represent that what is card status like active, deactivated, temp card, permanent card.
3) Transaction_Detail table has transaction_date column, which represent the when the transaction happen.
All the table have one common unique id - cad_number.
For resolve this type of issue I have created 3 calendar and working fine but issue occurs when App1 (based on Card_detail -- Insert_date) is opened and put 1 filter and same time in next tab try to open 2nd app(which is based on card_status -- modified date), 2nd App also open with same filter i.e. avaliable in 1st App window which shows as incorrect data, because in 2nd app the calendar is different fields but it shown in the respect of 1st calendar.
Then i read about Canonical Date, can i do this using this or not. If yes please suggest how. If not then please suggest me is there any option available in Qlik Sense when we open the new app there should not be any filter.
When i clear all the filter and open the 2nd or 3rd app its working fine.
Can you check this, may help up to certain extent,
https://community.qlik.com/t5/New-to-QlikView/Creating-a-Data-Model-with-Canonical-Date/td-p/1224631
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
Canonical Date can fit in,
In Each Table we will get different info like this,
card_detail table will tell how many new entries in particular period.
card_status table will tell classification of card status in particular period.
card_status table contains transactions done in particular period.
All above are inter linked.
I hope CardNo will be common among these all tables, based on that we can avail status and transactions by different data sets.