Conditional on table

[qlikviewaf]

hi Guys,

as you can see from the screenshot i created a table (Daily sales by region) and i would like to add a condition:

Show the data into the table data only when the "Invoice_Date" is unique. In the example, based on the selection i have 5 different dates, so the daily sales table should not show any data since this table is created just to show data of one day.

Is something possible?

Thank you

[m_woolf · Accepted solution]

For your Show Conditional on the chart, put

=GetPossibleCount(Invoice_Date)=1

[qlikviewaf]

it works! perfect! ... and do you know if will be possible to add a column which is the Month to date? regardless the fact that i selected just one day ?

thanks

[m_woolf]

If you search the forum for MTD, you will get many hits. Here is one:

Re: WTD, MTD Analysis