Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table with columns, but for single column it getting value displayed as -0 for every row of column. where actual calculated value will be -0.0546, -0.459 like so....
But i need it to display in percentage wise like -5.46%, -45.9% ...
How could i apply formatting for this particular column?
Hi
The format of the column can be changed by following steps,
1. Select the column and click on the arrow highlighted in black in the below image.
2. Select Format String and click on the one highlighted in the below image.
3. Select Percent.
Hope this helps!
Regards
Harish
Hi
The format of the column can be changed by following steps,
1. Select the column and click on the arrow highlighted in black in the below image.
2. Select Format String and click on the one highlighted in the below image.
3. Select Percent.
Hope this helps!
Regards
Harish
Hi Supriya
Did this work?
Regards
Harish
Hi Supriya,
If your data is in columns why are you using formulas? Can you share your project? Take a look at the attached example.
HTH - Daniel.
Hi daniel,
I am not using columns, using expression through fx.
formula:
if(metric=invitations,sum(invitation),meric=Landing page hits, sum(landingHits)))
Regards,
Supriya
Hi Supriya,
It will save a lot of time and effort if you create and share a sample project (NSQ, QVW & Template file).
Best,
Daniel.
Hi,
I have attached template npx file,Please have a look into it, if need any more information please ask
Hi Supriya,
Just the npx file will not help. At a minimum we also need the QVW and the name of the object(s) used in the template.
- Daniel.
Hi Harish,
Thanks for reply.
I figured out, why your answer was not working.
I was using formulas in Expression, and putting that in column. here the wrong i was doing is that, my expression was
text(if(metric=invitations,sum(invitation),meric=Landing page hits, sum(landingHits)))).
the text() function in expression, avoiding format string in column. So after removing text() and applying format string as you showed giving the result.
Now, if data is 0.99340 it gives me 99.3% How could i make it to display 9.93%, by applying format string.
Hey Daniel,
Sorry for taking your time, i figured out what was wrong, it was all in expression i was using text() which was used for formatting so it was overiding applying format string through smart tag.
Here i am using qliksense and Nprinting 17.2,so in NPrinting i am not able to use table object, as we do in images or fields. For this, as a workaround, my colleague found solution through levels(to take dimension through INLINE LOAD through Qliksense) and adding Expression.
Is there wrong assumption we have done regarding pulling table object not possible in nprinting using qliksense? your response will be very helpful for us.