topic Re: How to remove dash ('-') from Pivote table? in App Development

How to remove dash ('-') from Pivote table?

Madhab77 — Tue, 03 Sep 2019 15:19:24 GMT

Hi All,

The user has asked to remove (user wants blank) the dash ('-') from the following Pivote table. The Pivote table shows the first call, last call and the working duration, and these 3 columns are repeated for the entire month. The table shows '-' for all the 3 columns for a particular day if the user is absent for the day. Please provide any solution to remove the '-' from the Pivote table.

I tried, alt, isnull, if conditions, but all these did not work!

Thanks in Advance!

Madhab SIkder

Re: How to remove dash ('-') from Pivote table?

mahaveerbiraj — Tue, 03 Sep 2019 16:14:07 GMT

use like below .

alt(your expression,'')

for example : alt(1/0,'')

Re: How to remove dash ('-') from Pivote table?

Madhab77 — Tue, 03 Sep 2019 21:59:32 GMT

Hi, it doesn't work!

Re: How to remove dash ('-') from Pivote table?

mahaveerbiraj — Wed, 04 Sep 2019 04:17:46 GMT

please attach your qvf or send your expression

Re: How to remove dash ('-') from Pivote table?

Madhab77 — Wed, 04 Sep 2019 08:49:25 GMT

Hi Mahaveer,

Thanks for your activeness to resolve the issue. Today my user id got expired, so I am not able to login to my qliksense. It will take 1 day to re-activate id, once I get access, I will share the qvf.

Thanks & Regards,

Madhab Sikder

Re: How to remove dash ('-') from Pivote table?

Madhab77 — Wed, 04 Sep 2019 13:36:07 GMT

Hi Mahaveer,

The qvf file is very big. I am not able to upload it.

The field is for the

First call: 'Min([Start Time])',

Last call is "Max ({<[PDA Visits]-={''},[Sig Count]-={''}>+<Sig-={''}>}[End Time])" and for

Working day: Max ({<[PDA Visits]-={''},[Sig Count]-={''}>+<Sig-={''}>}[End Time])-Min ({<[PDA Visits]-={''},[Sig Count]-={''}>+<Sig-={''}>}[Start Time])

If there is null value it automatically takes 0. But think is that, if there is no data for a particular day, then it comes as '-'. As far as I know, any function will work on some values(either 0/null/ values, here in my case there is no records, so by default qliksense gives '-'.

Thanks & Regards,

Madhab Sikder