topic Re: Conditional on table in QlikView

Conditional on table

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional on table

m_woolf — Tue, 13 Jun 2017 15:26:59 GMT

For your Show Conditional on the chart, put

=GetPossibleCount(Invoice_Date)=1

Re: Conditional on table

qlikviewaf — Tue, 13 Jun 2017 15:29:25 GMT

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

Re: Conditional on table

m_woolf — Tue, 13 Jun 2017 16:50:53 GMT

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

Re: WTD, MTD Analysis