Qliksense KPI

[mandilicious]

Hi All

(1)

Please assist i have app that run successfully it run 3 times a day (8H00,13H00,17H00)i have created below indicator they working fine when you choose selectors  according(E.g. Month, Date etc. ),but the customer requested that they need to see accurate results without clicking  any of the selectors which will be refreshed data for (8H00,13H00,17H00)  each time when they open the app without choosing any of the selection?

(2)How can i remove below duplicate in my table when loading data?

Thanking   you in advance.

[d_prashanthredd · Accepted solution]

Hey you can add one more condition to your expressions.

like..

=Count(Distinct {$<Datefield= {">=$(=vEarlierRefresh)<=$(=vLtstRefresh) "}>} Service_order))

same condition Datefield= {">=$(=vEarlierRefresh)<=$(=vLtstRefresh) "} add to other expressions.

vLtstRefresh = Max(Timestamp(Date2, 'MM/DD/YYYY hh:mm:ss'))

vEarlierRefresh = Max(Timestamp(Date2, 'MM/DD/YYYY hh:mm:ss'), 2)

Do take care of your timestamp formats..

[mandilicious]

HI Prashanth

Thanks you very much for your help