Showing date column ignoring other tables

[qliker3]

Hi,

my tables are connected with date column. How do i show the date column from a particular table without other tables?

Kind regards

[SerhanKaraer]

Hello,

You must add flag fields into the tables in your model, so for instance you can count dates from table1 by using this expression: count({<Flag_Table1={1}>} DateField)

In this example, Flag_Table1 records are all 1s.

[Aditya_Chitale]

Create a flag in the table from which you want to show dates and use it in set expression as below if you want to add date as dimension:

=Aggr(only({<flag={'test_flag'}>}date),date)

Regards,

Aditya